Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««12345

Database backups best practice Expand / Collapse
Posted Thursday, August 28, 2014 12:49 AM



Group: General Forum Members
Last Login: Tuesday, October 25, 2016 8:37 AM
Points: 6,822, Visits: 8,830
itmanagers (8/27/2014)

Hope you are doing fine.

I'm new using SQL backup jobs with multiple full, diff and log backups.

I have the following scenario

full- every day at 8:00pm
diff- every 4 hours
log- every 30 minutes

with full and diff I think there's no issues, however, I have the following issue with log backups,

every time a new log backup is executed, a new file of 6GB is created, for example if a log backup of 6,163,694 KB is created, the next log backup size is 6,165,294 kb is created

as far as I know there's an option to create log backups with only the size difference between them.

Could you please give a hand with this?

thanks in advance

Please start a new thread.


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?

"press F1 for solution", "press shift+F1 for urgent solution"

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1608154
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse