Walkthrough: Backing up a database

This walkthrough of SQL Backup Pro will show you:

  • Step 1: Launch the Back Up wizard
  • Step 2: Choose to perform a new backup or use previously saved settings
  • Step 3: Choose the database and the type of backup to create
  • Step 4: Configure backup file settings
  • Step 5: Configure compression, encryption, network resilience and optimization settings for the backup
  • Step 6: Configure backup checks and email notification
  • Step 7: Review a summary of the options chosen
  • Step 8: Review the backup
  • Step 1: Launch the Back Up wizard

    Launch the Back Up wizard

    To back up a database we launch the Back Up wizard from the Back Up button on the toolbar.

    Step 2: Choose to perform a new backup or use previously saved settings

    Selecting the server to back up

    We now select the server from which we wish to back up the database. We can also choose to use settings from a template that we can customize and configure. In this case, we're going to create a new backup.

    Step 3: Choose the database and the type of backup to create

    Choosing the backup and the type of backup to create

    Next, we choose the type of backup we want to create and select the database we want to back up. If full backups have previously been made, we can decide to perform differential or transaction log backups. In this walkthrough, we create a full database backup.

    Step 4: Configure backup file settings

    Configuring backup file settings

    In this step, we decide whether to back up to a single file, a single file mirrored to a second location, or split the backup over multiple, smaller files. Splitting the backup across multiple files can reduce the time needed to create it.

    Here, we can also specify the file name of the backup or have it named automatically.

    If we need to purge older backups as part of the process, we can choose to overwrite existing files or delete existing backup files by age or quantity.

    If we want to copy the backup to a network location, we can also configure to which folder the backup should go and whether to purge existing backups at that location.

    Step 5: Configure compression, encryption, network resilience and optimization settings

    Configuring compression,network resilience and encryption settings

    Next, we can select one of four compression levels for our backup. If we are unsure which compression level to use, the Compression Analyzer helps us by sampling data to suggest the optimal compression level for our database.

    Here, we can also encrypt our data. With SQL Backup Pro, we can choose between 128-bit and 256-bit AES encryption.

    SQL Backup Pro lets us optimize the performance of our backup by selecting the number of multiple threads to be used for the backup process. We can choose a maximum transfer and data block size for memory and disk optimization.

    We can also protect our backup process against network outages, which can interrupt backup operations and cause job failure. SQL Backup Pro is designed to minimize the disruption caused by network outages by automatically continuing the data transfer once the connection is reestablished. By default, SQL Backup Pro is set to retry connecting to the network after 30 seconds and up to 10 times.

    Step 6: Configure backup checks and email notification

    Configure backup checks and email notification

    This new step gives us the option to test backup files when they are created by including CHECKSUM and RESTORE VERIFYONLY in backup jobs.

    CHECKSUM will validate any page checksums and generate a backup checksum. RESTORE VERIFYONLY will check the backup is complete and readable, and will validate the checksums. The results of the CHECKSUM and RESTORE VERIFYONLY will be recorded in the Activity History.

    We can choose to be notified by email with a copy of the completion log. By default, email notifications are only sent if errors occur during the backup process, such as the checksum failing if an error occurs. We can modify the email settings and choose to receive warnings or be informed about any outcome.

    Step 7: Review a summary of the options chosen

    Review a summary of the options chosen

    Before we start the backup we can review a summary of all the options we've chosen, and view the SQL script for use with the command line utility or stored procedure. We then click Finish to start the backup process.

    Step 8: Review the backup

    Review the backup

    We can now see from the timeline in the GUI that the database backup has been completed. The activity log will be updated automatically.

    And that's it! If you would like to see how your backup processes can be strengthened with SQL Backup Pro, try it now with a free, fully functional and supported 14-day evaluation.

    Pricing
    $995
    SQL Backup Pro is licensed and priced per server, with volume discounts available.

    Got a question?
    Download

    Try a 14-day fully functional free trial of SQL Backup Pro.

    SQL DBA Bundle
    SQL DBA BundleSeven essential tools for database administration.


    Contains:

    Find out more:

    Awards
    Community choice gold - Best backup and recovery product