Checking database backup history

Sometimes, especially with large databases, the duration of a backup can be significant (e.g. multiple hours). So, if you’re wondering exactly how far along a backup is, and when it is estimated to complete, you can run the query below I hope that helps!

Investigating a Log Shipping process

One of the clients that I support has a DR (Disaster Recovery) environment set up. If you want to read a description on DR (and by extension, Log Shipping), then check out this page from Microsoft. Log Shipping and DR were relatively new processes to…