SQLServerCentral / Discuss content posted by Jorge Novo / Article Discussions / Article Discussions by Author / Backup and Truncate Transaction Logs / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 03:07:01 GMT20RE: Backup and Truncate Transaction Logshttp://www.sqlservercentral.com/Forums/Topic607270-463-1.aspxGlad to helpTue, 16 Dec 2008 09:07:14 GMTJorge Novo-@ETLDEVDBARE: Backup and Truncate Transaction Logshttp://www.sqlservercentral.com/Forums/Topic607270-463-1.aspxThanks for the script Jorge; it's timely for us as we're going thru the very issue now of large transaction logs. For us, setting the access mode to single user while leaving the recovery mode in full did not work. We get: "Cannot shrink log file 2 (Logfile) because all logical log files are in use." We'll do as is in this script, set recovery mode to simple and shrink the log. We don't need the ability to restore to point of failure on this DB anyway.KenTue, 16 Dec 2008 08:18:32 GMTken.trockBackup and Truncate Transaction Logshttp://www.sqlservercentral.com/Forums/Topic607270-463-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Backup/65024/">Backup and Truncate Transaction Logs</A>[/B]Sun, 23 Nov 2008 20:09:55 GMTJorge Novo-@ETLDEVDBA