Match RPO and RTO to backups, log shipping, failover clusters, or availability groups, then test the full service recovery path.
SQL SERVER – Log Shipping Copy Job Failure – The Password for This Account Has Expired
A reader’s log shipping copy job was failing with ‘The password for this account has expired’. Here is how we found the cause and fixed it.
SQL SERVER – What is WRK file in Log Shipping?
Even if you have used log shipping for years, you may never have noticed the WRK file in log shipping. Here is what I learned about it.
SQL SERVER – Log Shipping – Sharing Tab Missing in Folder Properties
Setting up Log Shipping and found the Sharing tab missing in folder properties? A reader hit this, and here is how to get the Sharing tab back.
SQL SERVER – SSMS: Transaction Log Shipping Status Report
Like timber floating downstream, log shipping moves logs from one server to another. Here is how to read the Transaction Log Shipping Status report in SSMS.
Log Shipping to a Readable Standby: Restores vs Report Users
Configure a readable standby for log shipping, balance restore jobs with report users, and measure copy and restore delay.
Upgrading With Log Shipping for a Short Cutover
Upgrading with log shipping stages a newer secondary with NORECOVERY, applies logs in order, and leaves a short, rehearsed final cutover.