Tagged Questions

2
votes
0answers
31 views

Failover only working for Classic ASP, not ASP.net

Setup: All machines run Windows Server 2008 Enterprise SQL Server 2012 Standard (Primary) SQL Server 2012 Standard (Mirror) SQL Server 2012 Express (Witness) Root issue: Our ASP.NET application is ...
2
votes
1answer
97 views

Should I use Asynchronous Mirroring?

I plan on setting up mirroring on a SQL 2012 database which is currently in production. My concern though is how much it will affect the performance of the principal database. I am using mirroring ...
1
vote
4answers
243 views

Cannot remove Mirroring / nor restore or delete database:Error 3456 (SQL Server 2012)

I have a database that was a mirrored partner and went into suspended state. (Mirror Server was shut down). I took the principal database out of mirroring using SSMS. But now I am unable to restore ...
3
votes
1answer
137 views

How can I automatically trigger a script when my DB fails over?

I have some Windows services that I'd like to restart after a database failover but I can't find any details on triggering external actions after a failover. I'm working with SQL Server 2012 database ...