BACKING UP AND RESTORING DATABASESThe backup and restore component of Microsoft® SQL Server™ 2000 provides an important safeguard for protecting critical data stored in SQL Server databases.
With proper planning, you can recover from many failures, including:
- Media failure.
- User errors.
- Permanent loss of a server.
Using the Enterprise Manager to take backup of database:
1. Open the Enterprise Manager tool from the start menu.
2. Expand the server group, the corresponding server, and the database.
3. Right click on the corresponding database and choose All Tasks -> Backup Database…
- In the window displayed click on ADD button.
- Specify the path and filename by clicking on the browse button.
- click OK.
- Open Enterprise Manager Tool
- Create a database for backup copy to be restored.
- Right click on the newly created database and choose All Tasks à Restore Database…
- In the window displayed click the drop down button of “Show backups of database” and select the database name that is to be restored.
- Click on “Options” tab and make a check marks on “force restore over existing datbase”.
6. Cick ok. If we successfully restored the database into the new database, we will get the following message.