Monday, October 20, 2008

Clear database log files

USE database_name
GO
DBCC SHRINKFILE(database_name_log, 1)
BACKUP LOG database_name WITH TRUNCATE_ONLY
DBCC SHRINKFILE(database_name_log, 1)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)