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
2 minute read
SQL Server requirements vary based on the version.
5 minute read
Git can be an interesting learning curve if you are coming from TFS (Team Foundation Server). However, there are some great things about using Git if you can...
3 minute read
I’ve been in the process of migrating my site to it’s final home (as far as my inner geek can be satisfied staying with one platform)… Jekyll.
less than 1 minute read
I’ve made it my personal quest as a creative who has a passion for videography to try and capture simple moments during my life with family. There are plenty...