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:
- 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”.