How to see the size of a transaction log in SQL Server

Table of contents:

How to see the size of a transaction log in SQL Server
How to see the size of a transaction log in SQL Server
Anonim

Learn how to find the size of a transaction log and see the total space it uses in Microsoft SQL Server.

Steps

10500878 1

Step 1. Log in to SQL Server Management Studio

You can view the transaction log locally on the server or remotely.

10500878 2

Step 2. Select the desired database in Object Explorer

The latter is in the left column.

10500878 3

Step 3. Click New Query

This is in the toolbar at the top of the window.

10500878 4

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:

     
    
10500878 5

Step 5. Find the current log size

To see the total space used, enter this query and click on Execute in the toolbar:

     
    

Popular by topic