Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cleaning log and replication

Status
Not open for further replies.

Leonos

Programmer
Sep 17, 2003
32
NL
I have a merge replication setup, but my log-files are still growing.
Now I have read about the query BACKUP LOG [db] WITH TRUNCATE_ONLY (followed by shrink) that will clean these logs.

But...is the replication affected by this cleanup. With other words, does the replication-logreader use these logfiles ?

Leon
 
I have done some testing with this case and it seems that it doesn't matter.

I stopped the logreader for an hour, then lots of data was added to the publishers database.
The I flushed the log with the command above.

Then I started the logreader and it did read the correct amount of commands and transactions.

After synch the subscribers database was equal to the publishers database.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top