Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. CKG Edit ====== ====== 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