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.



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

What is the Use of isNaN Function in JavaScript? A Comprehensive Explanation for Effective Input Validation

In the world of JavaScript, input validation is a critical aspect of ensuring that user-provided data is processed correctly. One indispensa...