Scenario:
Usually, we will face log space issue in our SQL Server. Most of the time, we dont know the reason for our logfile space. I would suggest to get a third party tool to check it. By reading through some of the forums. I found there is some undocumented DBCC command which is used to dig the log file and get some information to us.
This command won't give a very great information at least we can get some high level information. Let's see the command,
DBCC Log(Databasename, Option number)
Default option number is 0
For instance,
dbcc log ('master',0) - 0 indicates a very minimal information.
The above command will provide the below details,
No comments:
Post a Comment