The backup software MS SQL module works very well and automates the backup process for your SQL database. To create a MS SQL backup set:
- Open the backup software client
- Click "Settings" icon at the bottom
- Click the "+" (plus sign) at the top left
- Name the backup set and choose "Microsoft SQL" from the TYPE drop down.
- Follow the wizard to complete the creation
By default your SQL backup set will have TWO schedules, one for the transaction logs (defaults to Mon-Thurs) and the second for the Database (defaults to Fri). The default schedules assume your databases are using the FULL recovery model. The recovery model is editable in the SQL database properties.
If your databases are using the SIMPLE recovery model, transaction log backups are not allowed and you'll receive the error " The statement BACKUP LOG is not allowed while the recovery model is SIMPLE" upon backup. In this case, you would remove the T-log backup schedule and set the single Database schedule to backup nightly. If the database is over 20G, it may be a good idea to change the recovery model to FULL (if not already) and keep the default schedules. This will allow for quicker backups during the week.
NOTE: A manual FULL backup is required for the initial backup of SQL. See the following FAQ: