Back-up and recoveries

BACKING UP AND RESTORING DATABASES

The 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.
Additionally, backing up and restoring databases is useful for other purposes, such as copying a database from one server to another. By backing up a database from one computer and restoring the database to another, a copy of a database can be made quickly and easily.
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…
  1. In the window displayed click on ADD button.
  2. Specify the path and filename  by clicking on the browse button.
  3. click OK.

Recovering Database:

  1. Open Enterprise Manager Tool
  2. Create a database for backup copy to be restored.
  3. Right click on the newly created database and choose All Tasks à Restore Database…
  4. In the window displayed click the drop down button of “Show backups of database” and select the database name that is to be restored.




  1. 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.






0 comments:

Post a Comment