Results 1 to 2 of 2

Thread: Restore Move

  1. #1
    Join Date
    Oct 2003

    Unanswered: Restore Move

    Okay so I am new to the SQL arena! Just wanted to get that out of the way!

    I have just set up a new SBS 2000 Server and am using SQL 2000 on it. I need to move a database from the old server, using SQL 7, to the new one. I have a backup of the old server db. However, I need to use the move command when restoring because the backup was done from drive D: and the new system is on drive c:.

    I can't seem to figure out the proper syntax for a batch file to use osql to restore/move the database. Any suggestion would be appreciated.



  2. #2
    Join Date
    May 2003

    Use Enterprise Manager ( Its easier ), unless of course you need to automate the task....

    in EM, right click on the database, choose All Tasks, Restore Database.

    Under the "General" tab, type the database name you want to create during the restore.

    Go to the "Options " tab.
    Change the "Restore As" path for each file ( MDF & LDF ) to be on the required drive & directory.

    All should work fine.

    Post back if problems.



Posting Permissions

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