Jump to content


Photo

SQL Backup Schedules

sql

Best Answer Shawn Lubahn, 12 January 2015 - 11:43 AM

Here's how you can control exactly when and what type of database backup you are getting:

 

1) Create two schedules for your SQL server(s). One with the backup type set to FULL, and the other set to LOG.

2) For the LOG backup schedule, configure that to be a repeating schedule throughout the day. In your case, every 15 minutes.

3) For the FULL backup schedule, configure that to happen just once a day. In your case this would happen once each night after your LOG backups end.

 

SMART mode is an easy way of automatically handling SQL backup jobs, but should probably only be used for customers backing up SQL once each day. For more information on how each backup type works, check out our TechLib article:  

 

https://techlib.barr...m/BBS/Schedules

Go to the full post


This topic has been archived. This means that you cannot reply to this topic.
1 reply to this topic

#1 DBA Team

DBA Team
  • Members
  • 1 posts

Posted 12 January 2015 - 10:43 AM

With SQL Backups in Smart Schedules - how to prevent full mid day backups...

 

Is it possible to prevent the barracuda from doing a full backup in the middle of the day while keeping the schedule to every 15 minutes so the log backups are continuous?

 

I want log backups every 15 minutes.

I want a full backup daily, but only to be performed from the hours of 6pm-3am



#2 Shawn Lubahn

Shawn Lubahn
  • Barracuda Team Members
  • 126 posts

Posted 12 January 2015 - 11:43 AM   Best Answer

Here's how you can control exactly when and what type of database backup you are getting:

 

1) Create two schedules for your SQL server(s). One with the backup type set to FULL, and the other set to LOG.

2) For the LOG backup schedule, configure that to be a repeating schedule throughout the day. In your case, every 15 minutes.

3) For the FULL backup schedule, configure that to happen just once a day. In your case this would happen once each night after your LOG backups end.

 

SMART mode is an easy way of automatically handling SQL backup jobs, but should probably only be used for customers backing up SQL once each day. For more information on how each backup type works, check out our TechLib article:  

 

https://techlib.barr...m/BBS/Schedules