Is there a graceful best practice to temporarily pause log shipping so that
unrelated Windows maintenance can be carried out on the servers?
Hi John
To pause Log Shipping, one can simply disable the Log Shipping jobs ie., the
Log Shipping Transaction Log Backup job on the Primary Server and the Log
Shipping Transaction Log Copy and Restore jobs on the Secondary Server.
Once the maintenance activity is completed you can enable the jobs again.
Thanks & Regards
Amer M J
MCP
"John Oberlin" wrote:
> Is there a graceful best practice to temporarily pause log shipping so that
> unrelated Windows maintenance can be carried out on the servers?
Wednesday, March 21, 2012
Pause Log Shipping for Server Maintenace
Labels:
carried,
database,
graceful,
log,
maintenace,
maintenance,
microsoft,
mysql,
oracle,
pause,
practice,
server,
shipping,
sql,
temporarily,
thatunrelated,
windows
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment