February 11, 2005 at 6:53 am
I had a transactional replication been up and running almost a year without rebuild. I noticed that the distribution databse grow to more than 10 GB. Is it normal ? Is there any maintenance I should do to clean it up ? The main table MSRepl_commands and MSRepl_transactions are all abot 6M+ rows. Is there anything I should worry ?
February 13, 2005 at 6:56 pm
What version of SQL Server are you running?
Why don't you,
(A) Shrink the Database
(B) Shrink the Transaction Log
(C) Set the Trincate Log on Checkpoint or Simple recovery mode for the Database. This also depends on what sort of backups you have implemented and whether your backing up the Transaction Log.
And your best off doing this when the Distribution Database is NOT in the process of replicating data to Subscribers or Publishing Subscribers.
February 13, 2005 at 7:43 pm
Check whether the replication cleanup job is running - it is responsible for deleting data from the replication tables once the transactions have been sent to the subscribers. 10GB does sound large for a distribution database.
February 14, 2005 at 8:20 am
I found all those rows are accumulated when the replication experienced problem on the past year. Most of the rows can deleted. All the replications jobs are functio properly. I managed to handle this but thanks for all the input.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply