Disable Replication, Keep Replicated Tables?

Asked Aug 07 '23 at 21:47

Active Aug 07 '23 at 22:22

Viewed 30 times

I have transactional replication set up between Database1 and Database2 using SQL Server 2017. About 20 tables are being replicated to Database2, a few of them are pretty large. I would like to disable replication but at the same time I would like to keep all the data being replicated to DB2 as well as the keys etc. In short, when I turn off replication I don't want to loose any of the replicated data.

Any recommendations?

edited Aug 07 '23 at 22:22

asked Aug 07 '23 at 21:47

user2608654

*SQL Server 2018* is not a SQL Server product. You can have 2016, 2017, 2019, 2022. – Stu Aug 07 '23 at 22:09
sorry for the fat fingers, i meant 2017 – user2608654 Aug 07 '23 at 22:23
Have you tested what happens if you drop the subscription? https://learn.microsoft.com/en-us/sql/relational-databases/replication/subscribe-to-publications?view=sql-server-ver16 – David Browne - Microsoft Aug 08 '23 at 00:16
I have not, cause unfortunately, I am not a DBA and I am not entirely confident in my ability to get it working again. – user2608654 Aug 08 '23 at 03:15
I suggest moving this question to "https://dba.stackexchange.com/" – Alex Aug 08 '23 at 08:28

Disable Replication, Keep Replicated Tables?

0 Answers0