Page History
...
- Create Backup and Restore Jobs using the SQL Server Agent.
- Create Backup and Restore Jobs using the SQL Safe Backup Agent.
Note |
---|
Note that SQL Server Express does not support the SQL Server Agent. Use the second option if you add any instance with SQL Server Express in your policy. This option allows the SQL Safe Backup Agent (second option) to create your log shipping policy job. |
...
- Whether the transaction log backup on the primary database has completed on schedule.
- Whether the transaction log restore on the secondary database has completed without warnings or errors.
- Whether the data on the secondary database is stable.
How do you control when a log shipping policy is compliant?
...