Backing Up a Database in SQL

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.
  • Reported : 9/1/2009
  • Version(s): Control All
You could leave a comment if you were logged in.