April 28, 2008 at 11:43 am
Hi All
I have a server that has been migrated from SQL 2000 to SQL 2005, i have tried to make replication from 2k to 2k5, and once i have changed the server, i saw some additional columns on all tables that have been replicated, now i can also see some views that starts with syncobj_0x*, and there are also some SP called as sp_MS*, i read some articles on the net, they say that this are used for replication, currently i am not using replication on this server, can i delete this objects, if so how can i delete it , please advise me on this
Cheers
Suji
April 29, 2008 at 5:25 am
I believe you wouldn't want to drop any of those objects because they are of no issue even if they aren't being used. Now, if you want to drop the column and delete the objects you will still have no issues. Your application should be up and running fine. If you think you will want to cleanup these objects created by replication, do it on a test environment to avoid any unknown outages.
Viking
April 30, 2008 at 3:16 am
Thanks for the post. i want to clear this replication objects, and there are some column in tables as well, that i wish to clear, i cant replicate this on a test environeint due to lack of resources, can u please suggest the worst scenerio that could happen if i delete this??
Cheers
Suji
May 1, 2008 at 8:33 am
You might try renaming the tsyncobj ables for a time and see if it causes any problems but I don't see why it should. The sp_MS tables are created by replication. Have you tried disabling replication first? I'm not sure how you do this on 2005.
Steve
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply