Great thanks. I plan on backing up the log frequently. James
----- Original Message ----- From: Damien Solodow To: NT System Admin Issues Sent: Tuesday, December 07, 2010 3:00 PM Subject: RE: Quick Newb SQL Question Yes. Just make sure to start doing log backups. DAMIEN SOLODOW Systems Engineer 317.447.6033 (office) 317.217.6851 (fax) HARRISON COLLEGE 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
