|
|
Posted by Query Builder on 09/13/07 18:50
Thanks for your response.. I tried dropping it thru QA.. Now the
replication doesn't show up on the publication. But the replication
monitor still has this replication with a failed status.....
Can you please point me to the direction on safely removing all
components of a particular replication module (I have other publishers
in this server)..
Thanks again..
Aravin Rajendar.
On Sep 13, 2:37 pm, "Hilary Cotter" <hilary.cot...@gmail.com> wrote:
> you should be able to drop them using query analyzer.
>
> --
> RelevantNoise.com - dedicated to mining blogs for business intelligence.
>
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com"Query Builder" <querybuil...@gmail.com> wrote in message
>
> news:1189702889.303360.189580@o80g2000hse.googlegroups.com...
>
> > Hi,
>
> > I have transactional replication set up on on of our MS SQL 2000 (SP4)
> > Std Edition database server
>
> > Because of an unfortunate scenario, I had to restore one of the
> > publication databases. I scripted the replication module and dropped
> > the publication first. Then did a full restore.
>
> > When I try to set up the replication thru the script, it created the
> > publication with the following error message
>
> > Server: Msg 2714, Level 16, State 5, Procedure SYNC_FCR To
> > GPRPTS_GL00100, Line 1
> > There is already an object named 'SYNC_FCR To GPRPTS_GL00100' in the
> > database.
>
> > It seems the previous replication has set up these system views
> > SYNC_FCR To GPRPTS_GL00100. And I have tried dropping the replication
> > module again to see if it drops the views but it didn't.
>
> > The replication fails with some wired error & complains about this
> > views when I try to run the synch..
>
> > I even tried running the sp_removedbreplication to drop the
> > replication module, but the views do not seem to disappear.
>
> > My question is how do I remove these system views or how do I make the
> > replication work without using these views or create new views.. Why
> > is this creating those system views in the first place?
>
> > I would appreciate if anyone can help me fix this issue. Please feel
> > free to let me know if any additional information or scripts needed.
>
> > Thanks in advance..
>
> > Regards,
> > Aravin Rajendra.
[Back to original message]
|