• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

stop sql replication

i need to modify 1 table in my publisher(i have one publisher and 1 subscriber)
i cant make the change untill i stop replication
whats the easiest way for me to stop replication so that i can modify
the table and set replication back
im using transactional replication
looking for a step by step
Thanks
0
dano992
Asked:
dano992
  • 3
  • 2
  • 2
  • +1
3 Solutions
 
dano992Author Commented:
sql 2000 by the way
0
 
SireesCommented:
0
 
SireesCommented:
contd..

at the very bottom of that page.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LowfatspreadCommented:
1. script out the current replications...
2. drop the replication (via the script)
3. backup your database
4. modify the database
5. backup the database
6. re-establish the replications...
7. backup your database again


hth
0
 
dano992Author Commented:
can i drop replication withougt  using a script?
0
 
vijay4sqlCommented:
IF it's a two way replication... synchronize the pub and the subs.
After making these changes u cant synchronize any old changes.

follow this to remove replication..
How to manually remove a replication in SQL Server 2000 or in SQL Server 2005.
http://support.microsoft.com/?id=324401

MAke the changes required.. and reconfigure the replication.

it's better to script out the publication.. just to be sure that we didnt miss any of the articles .. or filtering etc.. (kind of best practice)
thx
VJ

0
 
dano992Author Commented:
awsome thanks one more thing
hou do i change a subscriber database to be able to write to it
if publisher goes offline it seems that i cannot write to subscriber because its
part of replication
hou do i remove replication if publisher is down (say it crashed or something)
0
 
vijay4sqlCommented:
hou do i remove replication if publisher is down (say it crashed or something) -- On subscriber.. go to the subscribed DB and
Run

sp_removedbreplication
Removes all replication objects from a database without updating data at the Distributor. This stored procedure is executed at the Publisher on the publication database or at the Subscriber, on the subscription database.

Syntax
sp_removedbreplication [ @dbname = ] 'dbname'

Arguments
[@dbname =] 'dbname'

Is the name of the database. dbname is sysname, with no default.

0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now