But don’t forget that if backups are run without truncating the log files, your log files will quickly increase.
To find out the size of a database log file run the following Database Console Command (DBCC for short):
- In Microsoft SQL Server Management Studio (SQL Server 2005 or 2008), open New Query
- In New Query, type:
DBCC SQLPERF (LOGSPACE)
For more details on DBCC SQLPERF (LOGSPACE) see http://msdn.microsoft.com/en-us/library/ms189768.aspx