Log Shipping - Exclusive access could not be obtained because the database is in use.
Standby\Read-only in a log-shipping configuration and set @DisconnectUsers=1 for the subscriber. Log backups of the source db are taken every 15 minutes and then copied to the subscriber every 15 minutes, logs are applied 1x daily at 1 AM. (i.e. the users only need the data current up to 1 AM each day). Restore has failed 2 nights in a row with the error: "Exclusive access could not be obtained because the database is in use." This error occurred after the log-restore job had restored many (but not all) of the log backups from the past 24 hours.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.