To see how much MB your SQL Server log is, just run this query:

DBCC SQLPERF(logspace)
Advertisements