Backup and Truncate Transaction Logs

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

  • 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

  • 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