This post has moved : http://bradmarsh.net/index.php/2008/07/29/sql-2005-mirroring-automatic-failover/
July 29, 2008
SQL 2005 Mirroring – Automatic Failover – MOVED
Posted by bradmarsh under Microsoft, SQL Server, Techie[4] Comments
[4] Comments
July 29, 2008
This post has moved : http://bradmarsh.net/index.php/2008/07/29/sql-2005-mirroring-automatic-failover/
July 29, 2008 at 11:32 pm
[...] promised a new more in depth look auto- failover of SQL Mirroring, it can be found here, SQL 2005 Mirroring – Automatic Failover Possibly related posts: (automatically generated)SQL 2005 Vs 2008 BackupsDatabase Mirroring [...]
September 17, 2008 at 4:31 pm
Ah, thanks. This is exactly the problem we were having. I’m able to generate the command to add the login to the mirror, but it does not complete because it says the database cannot be opened “it is acting as a mirror database”
What can I do?
September 17, 2008 at 10:04 pm
brek the mirror then run the script, then re-mirror, that should fix it.
October 17, 2008 at 7:51 pm
[...] Handy SQL Server script for logins Filed under: Daily Stuff — kevenker @ 11:51 am I found this script on http://bradmarsh.wordpress.com/2008/07/29/sql-2005-mirroring-automatic-failover/ [...]