Go back to Knowledge Base
SQL DB logs are often growing but are not cleaned. In order to clear them, we can execute or schedule the following command:
backup log InstanceName with truncate_only
go
dbcc shrinkfile (InstanceName_log,0)
go
Go back to Knowledge Base
- Details
-
Written by Nicolas Buache
-
Created on Saturday, 14 January 2012
-
Last Updated on Saturday, 14 January 2012
-
Hits: 522
