Post reply

Backup and Truncate Transaction Logs

  • November 23, 2008 at 8:09 pm

    #196205

    Comments posted to this topic are about the item Backup and Truncate Transaction Logs

  • December 16, 2008 at 8:18 am

    #913174

    Thanks 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.

    Ken

  • December 16, 2008 at 9:07 am

    #913228

    Glad to help

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply