Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Problem setting transactional replication

  
   Database Forums (Home) -> Replication RSS
Next:  Are Express mdf files different?  
Author Message
Sandeep

External


Since: Apr 11, 2006
Posts: 11



(Msg. 1) Posted: Wed Nov 12, 2008 3:28 pm
Post subject: Problem setting transactional replication
Archived from groups: microsoft>public>sqlserver>replication (more info?)
SQL Server 2005 SP2

I am trying to setup transactional replication but getting error

Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line 27
Cannot drop the table 'dbo.MSpeer_lsns' because it is being used for
replication.

Today morning futher investigation revealed that is_replicated column in
sys.tables catalog view still has value 1. Is there any way we can set this
flag to 0?

TIA


Select is_replicated from sys.Tables where name = 'MSpeer_lsns'

 >> Stay informed about: Problem setting transactional replication 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 35



(Msg. 2) Posted: Thu Nov 13, 2008 12:00 am
Post subject: RE: Problem setting transactional replication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Sandeep - I've heard of this when restoring a replicated database but not
when setting things up. What about if you use the following system stored
proc before the setup: sp_MSunmarkreplinfo ?
HTH,
Paul Ibison, www.replicationanswers.com

 >> Stay informed about: Problem setting transactional replication 
Back to top
Login to vote
Sandeep

External


Since: Apr 11, 2006
Posts: 11



(Msg. 3) Posted: Thu Nov 13, 2008 9:33 am
Post subject: RE: Problem setting transactional replication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thanks Paul,

I tried sp_MSunmarkreplinfo, but it set value in replinfo column in
sysobjects table and it is already 0 for 'MSpeer_lsns'

Actually you are right, If I run sp_removedbreplication, I am getting same
error. Database had transactioanl replication and I noticed 'MSpeer_lsns' was
in sysArticles and sysubscription table. We deleted these entries.





"Paul Ibison" wrote:

> Sandeep - I've heard of this when restoring a replicated database but not
> when setting things up. What about if you use the following system stored
> proc before the setup: sp_MSunmarkreplinfo ?
> HTH,
> Paul Ibison, www.replicationanswers.com
 >> Stay informed about: Problem setting transactional replication 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 35



(Msg. 4) Posted: Fri Nov 14, 2008 7:05 am
Post subject: RE: Problem setting transactional replication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Just to confirm, so this error occurred after you took a peer and restored it
to another server then tried to set it up as another peer in a different
relationship? Sound like a bug in that case.
Cheers,
Paul
 >> Stay informed about: Problem setting transactional replication 
Back to top
Login to vote
Sandeep

External


Since: Apr 11, 2006
Posts: 11



(Msg. 5) Posted: Mon Nov 17, 2008 9:44 am
Post subject: RE: Problem setting transactional replication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
It had transactional replication. We restored database on another server. I
tried removeing replication on new server using sp_removedbreplication. I got
error, I noticed table 'MSpeer_lsns' in sysArticles and syspubluication
table.

Now I am even not able to setup transactional replication.


"Paul Ibison" wrote:

> Just to confirm, so this error occurred after you took a peer and restored it
> to another server then tried to set it up as another peer in a different
> relationship? Sound like a bug in that case.
> Cheers,
> Paul
 >> Stay informed about: Problem setting transactional replication 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Peer2Peer Transactional Replication - Hi, Anyone know why the view/ store procedure does not replicate from ServerA to ServerB? Thanks, Kenny

Bidirectional Transactional replication - Hi All Do any one know where to get good Knowledge resources for writing and implementing stored procedures for bidirectional transactional replication. I f any body has one implemented recently can you spare the steps involved and the best practises....

Schema changes screw up transactional replication - Hi We have two servers with SQL Server 2005, version 9.0.3042 on both. There is a transactional replication between them but when we make schema changes on the publisher something goes wrong. We get this error message Subquery returned more than 1..

transactional replication in 2000 compatibility mode - We're moving from a sql 2k 2-node cluster environment to a sql 2k5 three nodes running trans replication. but I have at least on compatibility issue that is preventing me from upgrading the database to 2k5 right away. I am planning to run sql 2k5, kee...

Transactional Replication where initial snapshot gets stored - Hello, I have a question that I cannot seem to find an answer to. When you setup transactional replication, you can configure it to use FTP to retrieve the initial snapshot. We have done this and it works pretty well. Unfortunately, recently we trie...
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]