Backup a SQL Database

Next Post
By Admin at 4 Nov 2014, 11:22 AM
    1. Use the Object Explorer and select the Server that the database is in
    2. Expand the Databases folder
    3. Right click on the database that you want to backup
    4. Highlight Tasks
    5. Select Backup
    6. A form will be displayed and you will be change the following options


      • Database – (defaulted to the database that you right clicked on)
      • Backup type –( Note that after creating a full database backup, you can create a differential database backup)
      • Backup Component
      • Backup name
      • Backup Description
      • Backup Expiration
      • To have the backup set expire after a specific number of days, click after (the default option), and enter the number of days after set creation that the set will expire. This value can be from 0 to 99999 days; a value of 0 days means that the backup set will never expire.
      • The default value is set in the Default backup media retention (in days) option of the Server Properties dialog box (Database Settings Page). To access this, right-click the server name in Object Explorer and select properties; then select the Database Settings page.
      • Tape or Disk- You are able to select whether you are going to write the back to a disk or a tape drive.
      • You must add the location that the server should write to when creating the backup by clicking the add button.
    7. Select an Overwrite Media option, by clicking one of the following:
      • Back up to the existing media set- For this option, click either Append to the existing backup set or Overwrite all existing backup sets. For more information, see Appending to Existing Backup Sets and Overwriting Backup Sets.
      • Optionally, select Check media set name and backup set expiration to cause the backup operation to verify the date and time at which the media set and backup set expire.
      • Optionally, enter a name in the Media set name text box. If no name is specified, a media set with a blank name is created. If you specify a media set name, the media (tape or disk) is checked to see whether the actual name matches the name you enter here.
      • Back up to a new media set, and erase all existing backup sets for this option, enter a name in the New media set name text box, and, optionally, describe the media set in the New media set description text box. For more information, see Creating a New Media Set.
    8. In the Reliability section, optionally check
      • Verify backup when finished.
      • Perform checksum before writing to media, and, optionally, Continue on checksum error. For information on checksums, see Detecting and Coping with Media Errors during Backup and Restore.
    9. If you are backing up to a tape drive (as specified in the Destination section of the General page), the Unload the tape after backup option is active. Clicking this option activates the Rewind the tape before unloading option.



    Post a comment

    Please correct the following: