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