Background: I
I recently inherited 50+ SQL Servers with 450+ databases. TheThe nightly backups are roughly 8TB and, needless to say, we're using more disk space than we'd like. AllAll of the databases are set to FULL recovery and the transaction logs have never been backed up. I've gone through all of the SQL Servers and identified LOWlow priority ones that only need a nightly backup and a days worthwhere a day of data loss in the even of a disaster will not be a problem (Fax databases and things like that)is acceptable.
Question: I'm
I'm switching a lot of low priority databases to SIMPLESIMPLE
recovery mode from FULL recovery mode (T-Logs and point-in-time recovery is not necessary)FULL
. WillWill the existing transaction logs be truncated (when checkpoints are created)? SomeSome of the existing transaction logs are 50-100GBs,100GBs; what is the best approach in determining what I should shrink them down to for the purposes of moving forward. I? I obviously don't want to keep them that large. OrOr, will they shrink on their own over time (I don't think they will)?