SQL Script to check space used by all log files

Leave a comment (0) Go to comments

Following script helps us to get

  1. Current total Log File size occupied by every database
  2. How much space is free inside a log file
-- ***********************************************************************************/
-- Description  :    Script to check space used by all log files  
--                        space used for all log files
-- Compatibility  :     7.0+
-- This Script should be executed in master
-- ***********************************************************************************/
use master
go
Dbcc sqlperf(logspace) 
go

OUTPUT


SQL Script to check space used by all log files how uch log file is used How much space is free inside a log file Current total Log File size occupied by every database Current consumed Log File size

EOF - SQL Script to check space used by all log files, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.