Backup and Transaction Log Maintenance

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Backup and Transaction Log Maintenance

12 posts, Page 2 of 2

««1 2

Backup and Transaction Log Maintenance

Rate Topic

Display Mode

Topic Options

Author

Message

craig.dixon

Posted Monday, January 07, 2013 9:46 AM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 6:06 AM
Points: 24, Visits: 94

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

SQLCrazyCertified

Posted Monday, January 07, 2013 9:56 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 12:12 PM
Points: 320, Visits: 1,916

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.

Post #1403722

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions