Home > IT Blogs > The Multifunctioning DBA/

The Multifunctioning DBA:

Mirror Fail over

1
June 22, 2011  8:23 PM

Fail over Mirror database with Powershell



Posted by: Colin Smith
DR, Mirror, Mirror Fail over, Powershell

Today I was asked if I could help out by writing a simple script that would fail over a mirrored database from one server to the other and back if and when needed. I thought sure I can. I mean to do the failover with T-SQL is really simple but I can automate it. So here is the T-SQL to fail...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1