Published on 18 مارس, 2013

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

Rate this article:
5.0
Comments (1)Number of views (2455)

Author: DoubleClick ERP

Categories: مدير النظام Admin

Tags:

1 comments on article "How To Back up and Restore Database in SQL Server2008 R2"

26
0

Ibrahim Ali

18/03/2013 11:07 ص

Very Good and Very Clear... Thanks

Leave a comment

Name:
Email:
Comment:
Add comment