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