sp_repldone won't truncate the log

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam - 28 Mar 2006 23:47 GMT

I have a SQL 7 database who's log is growing and cannot be truncated. It is a
copy of a database from another environment and is involved in Transactional
Replication.

When I try to run sp_repldone, it says the database is not published (which
is true). When I try to truncate the log with no_log option, the error msg
says I need to run sp_repldone to do so. What can be done here?

Adam

Reply to this Message

Paul Ibison - 29 Mar 2006 08:54 GMT

Adam,
try enabling the database for publication then run sp_repldone.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Reply to this Message

Adam - 29 Mar 2006 23:56 GMT

I published the database which enabled me to run the following SQL but I
still am getting the same error when trying to truncate the log

sp_repldone @xactid = null
, @xact_seqno = null
, @reset = 1

Adam

> Adam,
> try enabling the database for publication then run sp_repldone.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)

Reply to this Message

Adam - 30 Mar 2006 00:09 GMT

It finally worked but I had to also have a database subscribe to the
publication. Thank you for your help.

Adam

Reply to this Message

Paul Ibison - 30 Mar 2006 09:48 GMT

Thanks for the update Adam - I'll add this to my site under your name
(surname?).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Reply to this Message