Pages

Search This Blog

Thursday, June 21, 2007

T-SQL:Shrink Log File


use DatabaseName

BACKUP LOG DatabaseName With TRUNCATE_ONLY
GO
DBCC SHRINKFILE (Database_Log_FileName,300)
GO

No comments: