SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Disney Hammerschmidt / Truncate Transaction - All Databases / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 18:15:38 GMT20RE: Truncate Transaction - All Databaseshttp://www.sqlservercentral.com/Forums/Topic911351-2686-1.aspxHi,Please attempt to "truncate only" is a optional variable.You make any changes in code for work with SQL 2008.Try change for "NO_LOG".Plase, send me your response.Att.Disney Wed, 05 May 2010 13:33:18 GMTDisney HammerschmidtRE: Truncate Transaction - All Databaseshttp://www.sqlservercentral.com/Forums/Topic911351-2686-1.aspxIt works very well, except the err from SQL Server 2008:[i]Msg 155, Level 15, State 1, Line 1'truncate_only' is not a recognized BACKUP option.[/i]Thanks for sharing!RuthWed, 05 May 2010 13:10:24 GMTRuth Chen-435471RE: Truncate Transaction - All Databaseshttp://www.sqlservercentral.com/Forums/Topic911351-2686-1.aspxHi.. I agree that, but in some situations, you need to use alternatives methods.I make this script for automate tasks, not for "rule of tomb".You not need to use this everyday.Att.DisneyTue, 04 May 2010 11:19:06 GMTDisney HammerschmidtRE: Truncate Transaction - All Databaseshttp://www.sqlservercentral.com/Forums/Topic911351-2686-1.aspxHi.I´m using all databases listed in master.dbo.sysdatabases.You already have a sharepoint database in past?Records in your master database doest´t updated.Check this.DisneyTue, 04 May 2010 11:15:54 GMTDisney HammerschmidtRE: Truncate Transaction - All Databaseshttp://www.sqlservercentral.com/Forums/Topic911351-2686-1.aspxHmmm, I am trying to get away from "shrinking" anything. It is suggested that we should never shrink data files (fragmentation) and logs (breaking chain log).Mon, 03 May 2010 09:54:34 GMTsdesaiRE: Truncate Transaction - All Databaseshttp://www.sqlservercentral.com/Forums/Topic911351-2686-1.aspxHi,It have a error in script for database with -SharePoint_AdminContent_3a1c2eMsg 2520, Level 16, State 5, Line 1Could not find database 'SharePoint_AdminContent_3a1c2e'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.Good script !Mon, 03 May 2010 07:22:57 GMTrobert.coteTruncate Transaction - All Databaseshttp://www.sqlservercentral.com/Forums/Topic911351-2686-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Administration/70105/">Truncate Transaction - All Databases</A>[/B]Tue, 27 Apr 2010 12:24:30 GMTDisney Hammerschmidt