How to Check Transaction Log Size in a SQL Server

Advanced 20 min 5 steps 4806 views Rating: 3.5/5 Published: 2026-04-16

Log into the SQL Server Management Studio.. Select the database in the Object Explorer.. Click New Query.

Start Playback
S
Author

Steps

1

Log into the SQL Server Management Studio.

Step 1

Log into the SQL Server Management Studio.

2

Select the database in the Object Explorer.

Step 2

Select the database in the Object Explorer.

3

Click New Query.

Step 3

Click New Query.

4

Find the size of the transaction log.

Step 4

Find the size of the transaction log.

5

Find the amount of log space in use.

Step 5

Find the amount of log space in use.

View as Slideshow

Rate This Guide

★ ★ ★ ☆ ☆ 3.5/5
3

Comments (0)

No comments yet. Be the first to share your thoughts!