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.
- Log into the management portal and go to the computer account to which you want to add the SQL backup set.
- Go to the Backup tab and click the button next to SQL Server in the Backup Type section.
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.
- 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):
Select the SQL server you want to back up or the individual databases you want to include in the backup set and click Next .
- 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.
Hit Next to proceed.
- 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.
- 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.
Click Next to see a summary of the backup set or hit the Create Backup Set to create the backup set.