SQL Server Performance

Changing DB Recovery model from full to Simple in logshipping

Discussion in 'ALL SQL SERVER QUESTIONS' started by Ramut.sqldba, Apr 30, 2010.

  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?
  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.

Share This Page