This minHour teaches you how to find out the size of a database’s transaction log, as well as how much of the total log space it’s using, on a Microsoft SQL Server.
Steps
Log into the SQL Server Management Studio.
You can check the transaction log usage locally on the server or when connected remotely.
Select the database in the Object Explorer.
It’s in the left panel.
Click New Query.
It’s in the toolbar at the top of the window.
Find the size of the transaction log.
To view the actual size of the log, as well as the maximum size it can take up in the database, type this query and then click in the toolbar:
Find the amount of log space in use.
To check how much log space is currently in use, type this query and then click in the toolbar: