View Log file size in SQL server 1. Open SQL Query 2. Write DBCC SQLPERF ( LOGSPACE ) 3. Execute query