sp_repldone won't truncate the log -- sql server replication

Adam
3/28/2006 2:47:02 PM

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
3/29/2006 2:56:05 PM

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

[quoted text, click to view]

Adam
3/29/2006 3:09:03 PM

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

Adam

[quoted text, click to view]

Paul Ibison
3/30/2006 12:00:00 AM

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)

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : sp_repldone won't truncate the log