Managing Log Files Sizes the Easy Way
Learn an easy, rough, and ready way to manage log files in this piece.
2016-12-16 (first published: 2015-03-09)
9,767 reads
SQl Hunt,
2019-05-03 (first published: 2015-11-19)
declare @SQLPerfLogSpace table ( DBNAME sysname, LogSizeMB decimal(10,4), LogSpaceUsed decimal(10,4), Status Bit --Status of the log file. Always 0. ) insert into @SQLPerfLogSpace exec('DBCC SQLPERF(logspace)') select * from @SQLPerfLogSpace Order by LogSizeMB desc select * from @SQLPerfLogSpace Order by LogSpaceUSed desc
Learn an easy, rough, and ready way to manage log files in this piece.
2016-12-16 (first published: 2015-03-09)
9,767 reads
The transaction log is used by SQL Server to maintain data consistency and integrity. If the database is not in Simple-recovery mode, it can also be used in an appropriate backup regime to restore the database to a point in time.
2019-03-26 (first published: 2011-06-17)
24,337 reads
This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central....
2011-01-27
3,653 reads
I am planning on moving the SQL Server log file of my production database on this drive. I am curious about how it will optimize the performance. What are some of the considerations I should take into account and how can I move the SQL Server database log file to a separate physical location?
2009-07-02
3,723 reads
Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem.
2009-06-15
4,321 reads