Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Cleanup MSRepl_command and MSRepl_transaction tables in distribution db

1,456 views
Skip to first unread message

Nicole Williams

unread,
Jul 29, 2003, 1:24:19 PM7/29/03
to
Help,

My distribution database is growing very large. The job
Distribution clean up: distribution is not cleanin up the
tables MSRepl_Command and MSRepl_tranaction. The
MSRepl_Command table has over 2 million records. Does
anyone know of a way to safely clean these tables and then
automating this process. This is the code in the job.

<<<<dbo.sp_MSdistribution_cleanup @min_distretention = 0,
@max_distretention = 32760>>>>

Please feel free to email me directly.

Thank you everyone for your help.
Nicole W.

Narayana Vyas Kondreddi

unread,
Jul 29, 2003, 3:41:09 PM7/29/03
to
The distribution cleanup should take care of cleaning up the
msrepl_transactions and msrepl_commands. If it is not doing it, then one of
your distribution agents has either failed, or is stopped. Get it working
and these tables will get cleared up.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm


"Nicole Williams" <Nicole_...@Tiffany.com> wrote in message
news:003101c355f6$3e5501a0$a501...@phx.gbl...

Hilary Cotter

unread,
Jul 29, 2003, 8:11:15 PM7/29/03
to
Get Data Mirror off your freaking machine! That will solve all of your
problems:)

If you check the distribution retention period you will find it to be set to
a value in hours that is equivalent to almost 4 years. Data Mirror sets it
to this value for no apparent reason.

"Nicole Williams" <Nicole_...@Tiffany.com> wrote in message
news:003101c355f6$3e5501a0$a501...@phx.gbl...

Narayana Vyas Kondreddi

unread,
Jul 30, 2003, 2:26:48 AM7/30/03
to
Hilary, how did you figure out Nicole was using Data Mirror? :)
--

Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/


"Hilary Cotter" <hil...@att.net> wrote in message
news:u4T$Y8iVDH...@TK2MSFTNGP10.phx.gbl...

Hilary Cotter

unread,
Jul 30, 2003, 7:52:51 AM7/30/03
to
I had this vibe - a great distrurbance in the force -
100,000 voices crying out in agony.
>.
>

Hilary Cotter

unread,
Jul 30, 2003, 7:54:45 AM7/30/03
to
Seriously, Nicole works with me.

Data Mirror works wonderfully replicating from
hetergeneous data sources to SQL Server in most cases. It
seems a little problematic from SQL Server to SQL Server,
and there are a few problems when replicating from
Heterogenous Data Sources to SQL Server - this is one of
them. Can't say if its a bug or not.

>.
>

Narayana Vyas Kondreddi

unread,
Jul 30, 2003, 4:06:08 PM7/30/03
to
Okay, thanks for clarifying that :-) Yeah, I wouldn't use a third party
product for SQL to SQL replication!
--
HTH,

Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm

"Hilary Cotter" <hil...@att.net> wrote in message

news:0a5301c35691$5ee70170$a501...@phx.gbl...

0 new messages