Wednesday, March 28, 2012

migrating db

I have an ms sql 2000 db which I am migrating from one shared environment to another. How specifcally can I do this?

I have a copy of enterprise but not a full version of SQL on my local desktop.
The hosting company from which I am moving has placed the db as a zip file on the root of my site via ftp. I have unzipped it and it appears as a backup copy (.bak).

I appreciate any detail steps, I assume via enterprise, that anyone can give me. Thank you.Create a database on your server, and then restore the backup to it.
For detailed steps, see Books Online.

No comments:

Post a Comment