Yep, you defintely want to set it for full-recovery mode. This is why we control all DB installs, so that the vendors don't do whatever they feel like, and leave the users high and dry. ( Best you can do with Simple recovery mode is go back to the last full backup), with full recovery mode you can apply the latest backup and replay the transaction logs up to the minute you need the database back to.
Good reason to always use best practices, never give vendors SA, and apply least privilege when granting permissions to vendor accounts for access to their databases. 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: Wednesday, December 08, 2010 11:22 AM To: NT System Admin Issues Subject: Re: Quick Newb SQL Question 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 <mailto:[email protected]> To: NT System Admin Issues <mailto:[email protected]> 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 ~ 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
