Skip to main content
Barracuda MSP Partner Toolkit

Creating a SQL Backup Set

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:

  • In order to be backed up, databases must be in an "Online" state and have their "AutoClose" property set to "False." 

  • If the database is using "Full Recovery" mode, you will be unable to take differential backups.  To allow differentials, the database must be in "Simple Recovery" mode.

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 on the 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 button next it.  Then, select whether you want the new backup set to store its backups Local Only, Online Only, or Online and Local.

    Note: 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

    Select the SQL server you want to back up or the individual databases you want included in the backup set and hit Next.


  5. sqlsetup2.png Set a schedule for the backups by choosing which days the backup will run, and what method (full or differential) the backup will use.

    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.

    Hit Next to proceed.


  6. sqlsetup3.png 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.

    When finished setting an archiving rule, click Next.


  7. sqlsetup4.pngHere, 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.

    Click Next to see a summary of the backup set or hit the Create Backup Set to create the backup set.

  • Was this article helpful?