How To Back up and Restore Database in SQL Server2008 R2

To back up a database

1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database.
3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.
4. In the Database list box, verify the database name. You can optionally select a different database from the list.
5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE).
6. In the Backup type list box, select Full.
7. then click ok To Complete Your Operation. 

To restore a full database backup

1. After you connect to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
2. Expand Databases. Depending on the database, either select a user database or expand System Databases, and then select a system database.
3. Right-click the database, point to Tasks, and then click Restore.
4. Click Database, which opens the Restore Database dialog box.
In the Restore options panel, you can choose any of the following options, if appropriate for your situation:
• Overwrite the existing database
• Preserve the replication settings
• Prompt before restoring each backup
• Restrict access to the restored database

4:24 م