Differences
This shows you the differences between two versions of the page.
control_-_backing_up_the_database_in_sql [2019/01/27 11:28] |
control_-_backing_up_the_database_in_sql [2019/01/27 11:28] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== | ||
+ | |||
+ | |||
+ | |||
+ | | ||
+ | |||
+ | |||
+ | |||
+ | ===== 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, | ||
+ | - 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 | ||
+ | |||
+ | |||
+ | |||