Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Break the replication Expand / Collapse
Author
Message
Posted Friday, April 19, 2013 11:33 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 10:10 PM
Points: 147, Visits: 419

I have configured the Transaction replication

Here i want to know how to break the transactional replication and i want re create it

can u please provide the procedure for it
Post #1444682
Posted Saturday, April 20, 2013 11:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 21, 2014 7:40 AM
Points: 198, Visits: 666
Hi,

On the publisher instance right click Replication -> Disable Publishing & Distribution. Then follow through the wizard to disable it. Then create it as you did before.

Is this what you're looking for?

Dird



Dird // Junior DBA
11g OCA
10.5 newbie
Post #1444727
Posted Saturday, April 20, 2013 10:23 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 31, 2014 7:48 PM
Points: 119, Visits: 494
Hope this helps...!

http://msdn.microsoft.com/en-us/library/ms147921.aspx



use [$(PublisherDatabase)]

--Drop all subscriptions
exec sp_dropsubscription
@publication = N'TestPubs',
@article = N'all',
--@subscriber = [$(SubscriberServer)]
@subscriber = N'all',
@destination_db = N'all'

--Drop publication
if exists (Select 1 From SysPublications where name = N'TestPubs')
EXEC sp_droppublication @publication = N'TestPubs'

EXEC sp_replicationdboption @dbname = [$(PublisherDatabase)], @optname = N'publish', @value = N'false'

--Drop subscriber entry
EXEC sp_dropsubscriber @subscriber = [$(SubscriberServer)]

--Drop distributor
EXEC sp_dropdistributor @no_checks = 1


Cheers,
- Win
"Dont Judge a Book by its Cover"
Post #1444775
Posted Sunday, April 21, 2013 11:10 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 10:10 PM
Points: 147, Visits: 419
Yes

Thank you very much
Post #1444854
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse