It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda MSP Knowledgebase

Creating a SQL Backup Set

  • Last updated on

SQL backup sets allow you to back up and restore individual SQL databases. Before backing up a database, you should be sure it meets some prerequisites:

Once you have the prerequisites established, you can set up your SQL backup set.

Directions


  1. Log into the management portal and go to the computer account to which you want to add the SQL backup set.
  2. Go to the Backup tab and click the startbutton.png button next to SQL Server in the Backup Type section.
  3. First, set the name of this new backup set by clicking on the name at the top or on the editbutton.png button next it. Then, select whether you want the new backup set to store its backups Local Only, Online Only, or Online and Local.

    Depending how you have the Backup Agent and computer account configured, you may only see one or two of the storage type options. For more information on which types should be available, reference this article.

  4. Click the Discover SQL Servers button or enter the SQL server's address in the Address: field below to make it available to back up. If you do not know the SQL instance name, run this command on the server where the SQL instance resides (pay attention to capitalization): sqlcmd -L
    createsql1.png

    Select the SQL server you want to back up or the individual databases you want to include in the backup set and click Next .
  5. Set a schedule for the backups by choosing which days the backup runs, and what method (full or differential) the backup uses.
    By default, one full backup is scheduled. You can have more than one full backup scheduled but may not have fewer than one full backup. If you want to add more than one schedule, click the Add New button.
    createsql2.png
    Hit Next to proceed.
  6. On the Retention tab, adjust the archiving rule to your needs or check the box for Enable Advanced Archiving to use an advanced archiving rule instead of the default one. Information about advanced archiving rules is found here.
    createsql3.png
    When finished setting an archiving rule, click Next.
  7. Here, choose where you want the temporary folder to be and whether the backups will be copy-only backups. We recommend you have temporary space equal to or greater than the size of the largest database you are backing up.
    createsql4.png
    Click Next to see a summary of the backup set or hit the Create Backup Set to create the backup set.

 


Last updated on