Differences

This shows you the differences between two versions of the page.

Link to this comparison view

control_-_backing_up_the_database_in_sql [2019/01/27 11:28] (current)
Line 1: Line 1:
 +======  ======
 +
 +
 +
 + Backing Up a Database in SQL
 +
 +
 +
 +===== Steps =====
 +
 +
 +
 +  To back up a database 
 +  - When you connect to the correct instance of the Microsoft SQL Server Database Engine, look in Object Explorer, and click the server name to expand the server tree. 
 +  - Expand Databases, System Databases and select StoreData or whatever the system database is called for Control.
 +  - Right-click the database, point to Tasks, and then click Back Up. The Back Up Database will appear.
 +  - In the Database list box, verify the database name. 
 +  - You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 
 +  - In the Backup type list box, select Full.
 +  - Optionally, you can select Copy Only Backup to create a copy-only backup. 
 +  - For Backup component, click Database.
 +  - Either accept the default backup name suggested or enter a different one for the backup.
 +  - Choose the type of backup destination by clicking Disk or Tape. The selected paths are displayed in the Backup to list box.
 +  - To view or select the advanced options, click Options in the select a page pane. 
 +  - In the Reliability section, optionally check: verify backup when finished.
 +  - Click ok.
 +
 +
 +
 +===== Version Information =====
 +  * Reported : 9/1/2009
 +  * Version(s): Control All
 +
 +
 +