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


  • Please log in to reply
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
  • LocationAnn Arbor, MI

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