CIB Engineering

I often forget the importance of backing up your logs, as well as randomly dumping or shrinking your tables with DBCC the DBCC command, and its not until one would get any errors that any issues would arise. So if you find it useful, here is a good command to easily dump your logs and allow for continued and hassle free SQL usage.

Command:

backup log [database_name] with truncate_only
go
DBCC SHRINKDATABASE ([database_name], 10, TRUNCATEONLY)
go