Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Deleting Replication - What is removed?

Author  Topic 

Toothpick
Starting Member

4 Posts

Posted - 2013-11-28 : 05:46:37
Hi,

I need to delete a push subscription replication as it's no longer required.
Having read through the documentation i am slightly confused as to what actually is deleted.
My concern is that the actual data tables will be deleted when i remove replication. Is this true?
The db is running under sql server 2008 sp2 standard ed.

Thanks for advice.

Shane

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2013-12-05 : 19:51:01
The text that gets displayed is a bit confusing but not to worry. Removing replication only stops the updates from happening. Neither table (Publisher or Subscriber) is impacted from a schema or data viewpoint.

=================================================
No, no, you're not thinking, you're just being logical. -Niels Bohr
Go to Top of Page
   

- Advertisement -