Details

Powershell Smoke for SQL Server Mirrors

Speaker: Ed Snajder

Duration: 60 minutes

Track: 4 -Powershell

SQL Server mirrors are a great way to maintain highly available, fast-failover systems that run on independent disk sets. While it is easy enough to work through the GUI or T-SQL to manage your mirrors, if you have a lot of them, the processes can become tedious. Also, there is not a fast easy way to tear down and build up a mirror after something goes wrong.
I’ll show how I leveraged some of the SMO mirroring objects, so that I could not only build and tear down database mirrors efficiently, but to also monitor their health. These same objects can be used to build mirror-aware applications, or ones that could automate the provisioning of highly available databases for critical applications.

Accompanying Material

No material found.


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids