Damages of Replication

[CylonLove4Life]

I'm working on a database in which someone tried setting up replication and aborted it. I'm trying to undo the effects.

1) rowguid cols, and indexes for them, where added to all of the tables. Will these affect performance? Is it okay for me to delete them? (Again, at the end, we do NOT want to replicate)

2) I read that triggers are created also. I assume that these affect performance. How do I get rid of them?

3) What else can I , or do I need to , clean up?

Thank you.

 

[mrdenny]

When you completly remove replication the triggers should be removed. You can remove the columns.

That should be about all you need to remove. If the triggers are still there you can delete them.

Make sure you run through the wizzard to remove replication before you finish the clean up work.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[CylonLove4Life]

How can I tell if the triggers are still there?

Also, the rowguid columns are indexed. Should I remove this, as the index will slow down writes? Or just leave it?

 

[mrdenny]

You can either use the GUI and right click on the tables manager triggers or check out the sysobjects table.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

If replication got screwed up, there are some replication system tables which will (unfortunately) need to be edited and/or deleted to fix it. I remember having to go through this when I first installed Replication. I messed it up three times before I got it installed correctly.

Check out this link from Microsoft:

http://support.microsoft.com/kb/324401/en-us

And these user links for additional information:

http://www.sadikhov.com/forum/lofiversion/index.php/t27510.html

http://www.quest-pipelines.com/newsletter-v2/clean.htm

Using "Manually remove SQL Server Replication" as a search string in Google should get you more articles.

Hope this helps you out.

Catadmin


Catadmin - MCDBA, MCSA
"The only stupid question is the one you *didn't* ask.