Comprehensive data protection for all workloads
Post Reply
pufferdude
Expert
Posts: 143
Liked: 5 times
Joined: Jul 02, 2009 8:26 pm
Full Name: Jim
Contact:

SQL Server recovery model?

Post by pufferdude » Oct 04, 2010 3:17 pm

We've noticed that Veeam does not truncate our SQL Server 2008R2 transaction logs. Since we don't need up-to-the-minute recovery capability on this database, would we be better off switching SQL server to "simple" recovery model, so that we don't have to worry about Veeam not truncating the logs correctly?

Would like to know how other SQL Server shops handle this.

Gostev
SVP, Product Management
Posts: 24016
Liked: 3252 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Server recovery model?

Post by Gostev » Oct 04, 2010 6:41 pm

Hello Jim, yes I would recommend switching SQL server to "simple" recovery model if you do not need to point-in-time recovery capability. Or you can wait for v5 later this month where we have added automatic transaction logs pruning option. Thanks!

Post Reply

Who is online

Users browsing this forum: Baidu [Spider] and 13 guests