SQL Server Transaction Logs
Home > IT Answers > SQL Server > SQL Server Transaction Logs
RickMartinez
85 pts.
0
Q:
SQL Server Transaction Logs
SQL Server transaction logs, SQL Server logs, SQL Server log shipping, SQL Server backup, SQL Server 2005
If I change the recovery model on the primary database from full to simple and then change the primary database back to full again. Would that break the log chain? It seems the log shipping breaks after we do that.

Software/Hardware used:
SQL Server 2005
ASKED: Aug 18 2009  2:11 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46810 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Yes that would break the log chain. It shouldn't break replication, as all the transactions which need to be replicated should be marked in the transaction log as such, and they shouldn't be able to be removed from the log without being replicated, but I can see it causing problems.

What errors is it causing the replication agents to through?

When ever you change the recovery model of the database the next command you run should be a full backup.
Last Answered: Aug 18 2009  11:49 PM GMT by Mrdenny   46810 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0