January 30, 2015 at 4:03 pm
Hi,
How can we find how much log we need for our maintenance plan.
How you can say we required more logspace for the database
February 2, 2015 at 10:47 am
There are many views on this, of which you can easily find via google 🙂 My personal stance (without knowing how the DB is actually used) is to size my log file to be at least the size of my largest clustered index, + 10% - this is assuming the database is in full recovery, with regularly scheduled transaction log backups, and there's no unusual "churn" going on that would cause excessive growth from long running transactions, etc in the log file(s)
Here are a few resources to take a look at:
http://sqlmag.com/blog/sizing-your-transaction-log
https://technet.microsoft.com/en-us/magazine/2008.08.database.aspx
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply