p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2005 (http://p2p.wrox.com/forumdisplay.php?f=220)
-   -   Recovery model ??? (http://p2p.wrox.com/showthread.php?t=56601)

RinoDM April 12th, 2007 03:11 PM

Recovery model ???
 
Hi to all...
I have two live DB's which the Recovery model are set to SIMPLE...
I guess that's the reason why when I try to backup the transaction log it doesn't exist...
Can I set it too FULL automatic or should I wait until all users are off, do a backup first and then set it to FULL...

Thanking you in advance...

Rino...


happygv April 13th, 2007 12:48 AM

It is always better to wait until all users are off and set it to FULL to avoid any issues.

_________________________
- Vijay G
Strive for Perfection


All times are GMT -4. The time now is 07:44 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.