Thanks, I changed it in the management studio. I'm doing a full backup weekly, differentials daily and trans log hourly and also having backup exec grab those files nightly and put them on tape. The people (Henry Shein) who installed SQL and their software Dentrix setup the database in simple recovery mode. I knew with my limited knowledge that SQL 2008 had better backup functions then what's offered by simple mode, hence wanting to make the change, just wanted to make sure the change wouldn't screw anything up.
James ----- Original Message ----- From: Ziots, Edward To: NT System Admin Issues Sent: Wednesday, December 08, 2010 10:42 AM Subject: RE: Quick Newb SQL Question 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 ~ 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
