Replication issues after a Database Restore - Unable to drop or create Transactional Replication

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.

Re: Replication issues after a Database Restore - Unable to drop or create Transactional Replication

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 FTS
http://www.indexserverfaq.com
"Query Builder" 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.
>

Re: Replication issues after a Database Restore - Unable to drop or create Transactional Replication

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" 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" 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.