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: ,

2 comments:

  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
  2. kevoJanuary 6, 2014 at 3:47 PM

    For one database:

    BACKUP LOG database_name WITH TRUNCATE_ONLY
    GO
    DBCC SHRINKDATABASE( database_name )
    GO

    ReplyDelete

Subscribe to: Post Comments (Atom)