Hello all,
The HDD that holds the logs for one of our DB servers has run out of space (More has been ordered). Part of the reason for this is the log files have gotten rather large, as such the decision to drop the recovery mode of a few of the DB's to simple was reached. Daily differential backups are taken and this is enough for us at the moment. Now, what is the best practice way to change the recovery mode from Full to Simple?
Backup the log
Switch to simple
Shrink the transaction logs (through Enterprise Manager)
?
Cheers
The HDD that holds the logs for one of our DB servers has run out of space (More has been ordered). Part of the reason for this is the log files have gotten rather large, as such the decision to drop the recovery mode of a few of the DB's to simple was reached. Daily differential backups are taken and this is enough for us at the moment. Now, what is the best practice way to change the recovery mode from Full to Simple?
Backup the log
Switch to simple
Shrink the transaction logs (through Enterprise Manager)
?
Cheers
Comment