Good, looks like you have choices.
Tim
>Detach and attached worked.
>Also... check out what Bonnie suggested. That worked also.
>
>Thanx
>Neil
>
>>Hi Neil,
>>
>>>
>>>I have been using this trick of yours since 2004. Thank you ever so much.
>>>
>>>But today I have a new problem and I was hoping you could help once again. Server B is running the old sql server 2000 and contains NORTHWIND , which I modified. Server A has a fresh install of the new sql server 2005. When I attempt to run this trick of yours, sql server 2005 indicates that the the file that I am attempting to restore onto it is not a database file or is missing some components. Any thoughts? Please be gentle in your explanation. I am a vfp developer and know very little about sql server.
>>>
>>>Neil
>>>
>>
>>What if you upgrade server A first before detaching the file? How about if you do a detach and attach rather than a backup and restore?
>>
>>Tim
Timothy Bryan