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
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: Tuesday, July 14, 2015 12:28 PM
Points: 28, Visits: 177
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,
Post #1403714
Posted Monday, January 7, 2013 9:56 AM


Group: General Forum Members
Last Login: Yesterday @ 8:47 AM
Points: 438, Visits: 2,710

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.


Post #1403722
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse