dataplatform.blog
SQL Tips & Tricks
(updated on )

Claus Munch

Backup/Restore progress

Sometimes you just need to have an idea of how long a backup/restore has been running or maybe for how long it will roughly run.
Here's a small script, that will give you these indications.

SQL Tips & Tricks
(updated on )

Claus Munch

Database Mirroring to offsite server

Using SQL Server Database Mirroring to offsite servers, can at times be tricky, as latency becomes an issue.
At a recent engagement, they where experiencing that their mirror got suspended several times a day.