Log-shipping Queries

First check the last file copied and restored to the secondary. Run the following queries on the secondary node. The following query…

Read More

T-SQL to check the properties of all the databases on a server

Views – 2049

Read More

Configure Email Alerts via T-SQL

You can run the following SQL script to ensure email alerts are configured for the LSCopy and LSRestore jobs:

Views – 2404

Read More