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?
Showing posts with label thatunrelated. Show all posts
Showing posts with label thatunrelated. Show all posts
Wednesday, March 21, 2012
Pause Log Shipping for Server Maintenace
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 tha
t
> unrelated Windows maintenance can be carried out on the servers?
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 tha
t
> unrelated Windows maintenance can be carried out on the servers?
Labels:
carried,
database,
graceful,
log,
maintenace,
maintenance,
microsoft,
mysql,
oracle,
pause,
practice,
server,
shipping,
sql,
temporarily,
thatunrelated,
windows
Subscribe to:
Posts (Atom)