SQL 2000 dabase backup - please help !!!!

[bloomlight]

We are using SQL 2000 server and having backup job set up to run every night.

From time to time, I need to do some upgrading on the server. I would like to do manual database backup right before the upgrading.

When we had SQL 7.0, I had to create a database first and then copy data from the database I want to backed up to new created database. Do I have to the same?

What is the procedure to manually backup SQL 2000 database? Please help!!! Your help will be very much appreciated.

 

[onpnt]

Right click the database in Enterprise Manager. Scroll to all tasks. Select backup database. Add a destination in the backup to: section. Typically a network drive and make sure there is enough space on it.

This will create a .bak which is a full backup of the DB.

To restore from this backup follow the same procedure but select restore database. tick from device in the wizard and select "Select Devices" Add the .bak file you created then



____________ signature below ______________
General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[SQLBill]

Even easier....you have a backup job already created. Just right click on the backup job and select Start Job. Depending on how many steps the job has one of two things will happen. If there is only one step, the job will run. If there are more steps, it will ask you which step to start with. If you only want one step of a multi-step job to run, double click on the job (or select Properties), go to steps, click on a step and go to the advanced tab. Set the step that you WANT to run as Quit on Success. Then run just that step. Remember to set it back after you run it.

Or you could copy that command into Query Analyzer and run it.

-SQLBill

Posting advice: FAQ481-4875