Find out the size of a SQL server's transaction log (with pictures)

Table of contents:

Find out the size of a SQL server's transaction log (with pictures)
Find out the size of a SQL server's transaction log (with pictures)
Anonim

This wikiHow 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 uses on a Microsoft SQL Server.

Steps

10500878 1

Step 1. Log in to SQL Server Management Studio

You can monitor the transaction log usage locally on the server or through a remote connection.

10500878 2

Step 2. Select the database in the Object Explorer

You'll find it in the left panel.

10500878 3

Step 3. Click New Query

It's 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 size it can occupy in the database, type this query and then click To carry out in the main menu:

     
    
10500878 5

Step 5. Find the amount of log space in use

To check how much log space is currently in use, type in this query and click To carry out in the main menu:

     
    

Popular by topic