Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 10:42 AM
Points: 6,731, Visits: 8,480
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


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