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

  • Once again, thank you...

    In the interests of paranioa, I ran log backups of the 6 biggest log files to disk on the server. Thanks to Enterprise Edition, the backups used about 10GB total (compression on for the backup)

    The data space used by all the log files?

    Went from ~46GB to ~5GB...

    So yeah, when the SP Admin is ready to purge out his audit tables, I'm going to kick the DBs to Simple, let him do his thing, then back to full (making sure we've got a backup from before he starts, just in case...)

    Once more, thank you!

    Jason