Tuesday, February 24, 2009

quiescing a replication system

to do this you will need to first suspend all the log transactions do this by

isql -S server_rep -U repadmin -P password

admin health
go

this well show false of quiese is not right
next run
suspend log transfer from all
go
then run
admin quiesce_force_rsi
go
then run
admin quiesce_check
go

this should now say the server is quiesce
I would recomed doing this 2 to 3 times more before restoring the log transfer as sometime it does not work.

No comments:

Post a Comment