Post reply

Transaction log maintenance and read only db's

  • January 13, 2012 at 12:26 pm

    #1433472

    GilaMonster (1/13/2012)

    jshurak (1/13/2012)

    Is there anyway to reduce the file size without taking the database out of read only mode?

    No.

    Alter the databases to read-write, set recovery model to simple, take a backup, shrink the log to a reasonable size and set it back to read only.

    Thanks. This is what I ended up doing. I needed to verify with the vendor that the application wouldn't have any issues. Thanks

Viewing post 16 (of 15 total)

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