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 ««12

Backup and Transaction Log Maintenance Expand / Collapse
Author
Message
Posted Monday, January 7, 2013 9:46 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 1, 2014 2:33 AM
Points: 28, Visits: 164
Hi again everyone,

Thanks for all your advice today, I've had a good look at how things are working and I've decided to try a few different setups on my test environment and leave them running for a couple of weeks to see how our production environment would handle them. You've been a great help Gila, I will take your advice on board and hopefully I'll get everything working how it should.

You've all been brilliant,
Kindest Regards,
Craig
Post #1403714
Posted Monday, January 7, 2013 9:56 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 8:21 PM
Points: 417, Visits: 2,558
Craig,

The best way to go about it is to find the SLA/RTO and create a backup plan based on it. For example if your SLA requirement is for 2 hours data loss, then create a backup plan as such:

-Weekly Full Backup
-Daily Differential
-Log backup every 2 hours.

SueTons.


Regards,
SQLisAwe5oMe.
Post #1403722
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse