itmanagers (8/27/2014)
Hi,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.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- 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