Results 1 to 2 of 2

Thread: migrating db

  1. #1
    Join Date
    Mar 2007
    Posts
    2

    Unanswered: 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.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Create a database on your server, and then restore the backup to it.
    For detailed steps, see Books Online.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •