1. Ramut.sqldba New Member

   Hi, Here I have question for you, Consider the logshipping on a DB is setup and working good. Suppose i have changed the recovery model from ful to simple. If i do, i think it truncate the logs once it reaches a level of 70% in simple recovery model. Then after sometime i changed the recovery model to Full. So what will be effect on logshipping?

   Ramut.sqldba, Apr 30, 2010

   #2
2. Luis Martin Moderator

   Welcome to the forum!!
   If you change from Full to Simple you will loose logshipping capability.
   After back to Full, then logshipping will work from fresh start.
   

   Luis Martin, Apr 30, 2010

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in