dano992
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
contd..
at the very bottom of that page.
at the very bottom of that page.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
can i drop replication withougt using a script?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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)
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)
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.
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.
ASKER