Connecting Tech Pros Worldwide Forums | Help | Site Map

Change Recovery Mode from Full to Simple

Member
 
Join Date: Aug 2007
Posts: 34
#1: Apr 24 '08
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

debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,511
#2: Apr 24 '08

re: Change Recovery Mode from Full to Simple


Better to backup the log and remove those from HDD.
Reply