SQL Server Transaction Logs

585 pts.
Tags:
SQL Server 2005
SQL Server backup
SQL Server log shipping
SQL Server logs
SQL Server transaction logs
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: August 18, 2009  2:11 PM
UPDATED: August 18, 2009  11:49 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following