How to restore SQL server 2000

[ericwi]

Hi all,

I have used ARCserve 2000 to backup my SQL server 2000. I would like to know how to restore certain database from tape into my operational SQL 2000 server.


Thks.

 

[cwcrawley]

How have you backed up your SQL server data? did you run a DTS job on the SQL databases and then backup those files?

I've not used Arcserve 2000 yet in any anger, so am unsure whether it allows you to backup a database direct from the app itself..

If not, just put your tape in, go to restore, restore the Database backup file in question and then do a normal SQL restore... should work fine. (thats how I do it anyway.)

 

[ACiDelic]

You use the Restore manager to create restore job. You need to select what database or session you want to restore, select a destination and then run the job.

To restore to a different machine than the one where the db was backed up on, use the Destination tab to select the SQL agent on the machine. You can restore the db with a new name by adding it to the destination path.

If the data and log files need to be moved to a different location during the restore, use the Backup agent options screen.

The SQL agent guide has detailed instructions for restoring SQL data.