Solved

How to disable or deactivate the replication on a database for sometime?

Posted on 2014-02-06
2
205 Views
Last Modified: 2014-02-08
I would like to disable or deactivate the replication on a database for sometime. My database is configured as Publisher for replication.


Please suggest.
0
Comment
Question by:Easwaran Paramasivam
2 Comments
 
LVL 25

Accepted Solution

by:
jogos earned 300 total points
ID: 39841188
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39842538
Are you trying to remove replication or just disable?  If you just want to temporarily disable all you have to do is stop the SQL Server Agent Replication jobs.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now