August 5, 2010 at 12:01 pm
mhilligas (8/5/2010)
is_auto_close_on = 1
Turn it off. That's why the DB's repeatedly going offline.
Not sure how to check dataloss allowance
Um, that's not something that you look for in the database. That's something you ask your users. If something happens and the database fails, how much data are they prepared to lose? A full day? A week? A month? All of it? Less than a day?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 12:15 pm
You also need to do something about that transaction log. My guess - too many VLFs and too large. Would explain why recovery's taking long. See http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx for advice on fixing that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply