Skip to main content
Intronis 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. Click on the Backup tab and then on the Add Backup Set button to launch the Create Backup Set wizard.
     

  3. On the first page, select SQL as the backup set type from the left-hand side, then give the backup set a name and select a backup destination.  Click Next when you are done.
     


  4. On the next page, click sqlsetup2.pngon the Discover button to find a local instance of SQL or type in the address of a remote SQL instance.  If you do not know the SQL instance name, run this command on the server where the SQL instance resides:

    sqlcmd -L

    Select the SQL instance name to back up all databases or click on the arrow to the right of the instance name to expand the list of databases and choose the one(s) to back up.  Hit Next to continue.

    Note:  If you do not see either the SQL instance or databases you want to back up, you will need to run the Backup Agent service as a user with sufficient access permissions.  If you log into SQL Management Studio with Windows credentials, run the Backup Agent with those.


  5. On the Schedule page, decidesqlsetup3.png when the backup set runs and whether or not it runs a full or differential backup.  When you have finished setting a schedule, click Next to go to the Settings page.


  6. On the Settings page,sqlsetup4.png you can set the archiving rules and temporary folder location.  In addition, you have the option to enable "Copy-Only" backups.  When you are done, hit Next to continue.

    • Archiving Rules - For SQL database backups, full backups count as versions while differential backups do not.

    • Temporary Folder - You will need to have at temporary space equal to or great than the size of the largest database you are backing up.  If you are backing up a remote SQL database, make sure to put the temporary folder on the same machine as the remote SQL database.

       

  7. On the last page, you will be given a summary of the backup set you just configured.  If everything looks to be in order, click on Create to finalize the backup set.

  • Was this article helpful?