Home Forums SQL Server 2008 SQL Server 2008 - General *MAY* need to switch DBs from Full Recovery to Simple, due to backup space issues... RE: *MAY* need to switch DBs from Full Recovery to Simple, due to backup space issues...

  • jasona.work (4/3/2013)

    ScottPletcher, Once the SP Admin gets done with clearing out the old audit information, actually reducing the on-disk size of the logs (and as you suggest, setting their size to have a "reasonable" number of VLFs) is next on the plate.Thanks,

    Jason

    Personally, if I were you, I'd consider leaving the db in simple mode while clearing out the old audit information, assuming you are deleting in batches. Then you wouldn't have to do a tlog backup inbetween each audit batch.

    Do an incremental backup when done with deletes and go back to FULL mode then.

    Btw, I suggested clearing the logs immediately also because it will give you space to back up other logs to, even if that's not the drive where you normally store log backups. If the log backup is just an intermediate file, it doesn't really matter where it goes on disk (other than overall performance, but that is secondary right now).

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.