Friday, August 26, 2011

T-SQL: Clear transaction logs for all databases

Works only for SQL2005

EXEC sp_MSforeachdb @command1 = "BACKUP LOG ? WITH TRUNCATE_ONLY DBCC SHRINKDATABASE( ? ) "


Posted by kevo at 5:55 PM
Labels: ,

1 comment:

  1. AnonymousJanuary 27, 2012 at 10:08 AM

    Clearing out data can be done through this method. It depends on how you configure the tool.

    SEO Philippines

    ReplyDelete

Subscribe to: Post Comments (Atom)