A standard way to provide for database-server disaster recovery is to prepare a standby server — a secondary database-server computer that maintains a somewhat current version of your production ...
The log shipping backup jobs that were previously unable to ship log on that database, begin shipping log. Conversely, a failover causes the former principal/primary database to become the new ...
So you decided to set up log shipping in order to establish a failover server, but what's next? Log shipping only takes care of keeping a user database in sync from one server to the other. In the ...