How can we Help ?

Create Microsoft SQL backup set

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: 

  1. Open the backup software client
  2. Click "Settings" icon at the bottom 
  3. Click the "+" (plus sign) at the top left
  4. Name the backup set and choose "Microsoft SQL" from the TYPE drop down.
  5. 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:
 
 
Average rating:0 (0 Votes)

Contact Information

  • XZBACKUP
    2850 Interstate Dr. #2, 33805
    Toll-Free: +1 800.213.2157
    US Local: +1 727.564.9230
    UK Local: +44 2036.080613
    Phone Hours: 9AM - 6PM EST
    E-mail: sales@xzbackup.com
    Website: www.xzbackup.com
Copyright © 2015 xzbackup.com. All rights reserved.