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

  • Everyone: Thank you for the ideas / suggestions

    dan-572483 - Right now I'm not worrying about shrinking the files, that will come later. We're OK on disk space on the log drive, unless I back the logs up to that drive to try to fix this...

    I did give the DBCC OPENTRAN a try, and there were no open transactions, so that's a good thing...

    Gail - That's probably what I'm going to end up doing, although I'm still trying to find a better solution with the backup Admin.

    Scott - That's what I'm planning at this point when the SP Admin comes back from his vacation and is ready to try again. He'd be most likely doing this on a weekend, so after our "end of the day" TLog backup, I'd kick the DBs to Simple, he'd fire off his Powershell (provided by MS for just this purpose) to clear out the audit entries in batches, then when he's done, we'd kick the DBs back to Full recovery in plenty of time for our start of the week full backup.

    Once again, thanks everyone!

    Jason