Nope, you should keep your production DB's in full recovery mode. You can switch that in the SQL management Studio under options I believe, or via TSQL ( Look in books online, they have the syntax)
Z Edward E. Ziots CISSP, Network +, Security + Network Engineer Lifespan Organization Email:[email protected] Cell:401-639-3505 From: James Kerr [mailto:[email protected]] Sent: Tuesday, December 07, 2010 2:59 PM To: NT System Admin Issues Subject: Quick Newb SQL Question I have a SQL 2008 R2 database that was setup with the simple recovery model. It has been in production for a couple of weeks now. I would like to change it to full recovery model. Can I change this now without anything blowing up? James ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
