Tag: DBCC

Commands to shrink the SQL Server transacation log

I recently encountered a database that was 4 MB in size with it’s respective transaction log at 460 MB. The transaction log is used in a recovery model to restore the database to a point in time. I wanted to reduce the size of the transaction log. More importantly, I wasn’t exactly clear as to why a transaction log of…

Read More »