Creating An On-Demand Database Backup In MS SQL Server 2005

  1. Open Microsoft SQL Server 2005 Management Studio, log in, and navigate to the database you want to back up.
  2. Right click the database you want to back up. A context menu will appear.
  3. Select Tasks and Back Up... in the context menu. The Back Up Databases window will open.
  4. Select the database you want to back up from the Database drop down list in the Source group.
  5. Select “Full” from the Backup type drop down list in the Source group.
  6. Select the “Database” radio button in the Backup component list in the Source group.
  7. Type a backup name in the Name field of the Backup set group.
  8. Type a backup description in the Description field of the Backup set group.
  9. Select the After radio button in the Backup set will expire group.
  10. Type “0” (zero, without quotes) in the days field of the Backup set will expire group.
  11. Click the Disk radio button in the Destination group.
  12. Click Add in the Destination group. The Select Backup Destination window will open.
  13. Click the Browse button ( ). The Locate Database Files window will appear.
  14. Browse to and select the location in which you want to create your database backup file.
  15. Select “Backup Files(*.bak, *.trn)” in the File of type drop down list.
  16. Type a file name in the File Name field. Make sure to include the “.bak” extension.
  17. Click OK when finished. The Select Backup Destination window will open again, displaying the selected backup destination and file name.
  18. Review your selected destination and click OK. The Select Backup Destination window will close and the Back Up Database window will reappear, displaying the selected backup destination and file name.
  19. Review your backup settings and click OK. The database will begin backing up. A progress indicator will appear in the lower left hand corner of the Back Up Database window.

    When the backup is complete, the Complete window will appear.
  20. Click OK in the Complete window. The window will close and return you to the MS SQL Server 2005 Management Studio.
    At this point you have successfully created a full backup of your database. You can repeat this procedure for other MetaCommunications databases you want to back up.
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.