Search Open/Close
Open/Close Header Details
Search
How To Back up and Restore Database in SQL Server2008 R2
DoubleClick ERP / 17 مارس, 2013 / Categories: مدير النظام

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.

Image

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

Image

Click to watch video

Image
Print
Rate this article:
4.7
3600
Back To Top