Changing Recovery mode from simple to Full

Question

Changing Recovery mode from simple to Full

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

I would do it before users get on the system. After you switch to full recovery mode, do a full backup and then start your transaction log process to start log chain.

Also, if you haven't already, be sure to read BOL for more information.

pinky SSCommitted Points: 1997 More actions · Answer 2

Yes i would take a full backup and then start the Tlog backup process soon after i switch the database to full. can you please let me know if it locks the database when switching the recovery mode.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

You shouldn't see any real hit on your server during the change.

Bulent Gucuk SSCertifiable Points: 5508 More actions · Answer 4

You can change the recovery mode anytime you want or you need. In this case after you change the recovery mode to full make sure you get a full backup the database then schedule you tlog backups how often you need.

Good day,

Bulent