Quick snippet I threw together to help with failing over synchronized databases to the other server in bulk. No way I want to click that darn Fail-over button repeatedly. This scripts the statements to print (i commented out the exec portion) so that you can preview the results and run manually.Note that it’s also useful to have a way to do this as leaving databases running on the mirror server for an indefinite period can violate licensing terms on the secondary server when it’s a fail-over server and not meant to be the primary.
You may also enjoy
3 minute read
What is the best way to debug more complicated parameter binding and type casting scenarios in PowerShell.
1 minute read
Just a quick look at the very beginning of setting up SQL Server Database Experimentation Assistant
5 minute read
Migrating from hipchat to slack can be a little painful if you have some issues similar to mine to cleanup. Maybe this will help save you some time.
2 minute read
Trouble with duplicate files in Google Drive? Want to fix a mess? Found the tool to do it!