How can we identify used space in log file?


Many times we face this question in the interview “How can we identify used space in log file”.

 Using following DBCC command you can identify the used space in the log file.


DBCC SQLPERF('LOGSPACE')



Result:















You can see in result first column display DB name and second columns display total log file size in MB while the third column contains used size in MB which is our answer.

No comments:

Post a Comment

Please do not enter any spam link in the comment box.

Related Posts

Fatal Error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails.

Problem: Sometimes, we get the following error when trying to make a connection in Rails.  FATAL ERROR: Peer authentication failed for us...