(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.)
A quick one this time… Jonathan was working with a client recently who was experiencing weird, random failures on a log shipping secondary server. The log backups were set to restore and put the database in STANDBY mode and the option ‘Disconnect users in the database when restoring