By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,363 Members | 2,440 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,363 IT Pros & Developers. It's quick & easy.

Change Recovery Mode from Full to Simple

P: 34
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)


Apr 24 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,127
Better to backup the log and remove those from HDD.
Apr 24 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.