Скачать или смотреть Log Shipping in SQL server || Log Shipping Configuration || Ms SQL

SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances.
The transaction log backups are applied to each of the secondary databases individually.

An optional third server instance, known as the monitor server, records the history and status of backup and restore operations and, optionally, raises alerts if these operations fail to occur as scheduled..


1. Back up the transaction log at the primary server instance.
2. Copy the transaction log file to the secondary server instance.
3. Restore the log backup on the secondary server instance.

HA and DR :    • High Availability and Disaster Recovery in...  

Find and fix orphan users in SQL server, watch link
   • How to Find and Fix Orphan Users in SQL Se...