Learn how to find the size of a transaction log and see the total space it uses in Microsoft SQL Server.
Step 1. Log in to SQL Server Management Studio
You can view the transaction log locally on the server or remotely.
Step 2. Select the desired database in Object Explorer
The latter is in the left column.
Step 3. Click New Query
This is in the toolbar at the top of the window.
Step 4. Find the size of the transaction log
To see the actual size of the log, as well as the maximum usable size, enter this query and click Execute in the toolbar:
Step 5. Find the current log size
To see the total space used, enter this query and click on Execute in the toolbar: