Posts Tagged SQL Server

Flushing SQL Transaction Logs

Can never remember the syntax so here is is as a reminder:

Make the database current then run

DBCC

 

SHRINKFILE(‘Foo_LOG’,1) 

 

BACKUP

 

LOG Foo WITH TRUNCATE_ONLY  

 

DBCC

 

SHRINKFILE(‘Foo_LOG’,1) 

 

go

 

 

, ,

No Comments