All Questions
7 questions
8
votes
3
answers
1k
views
Is there an easy way to trigger automatic failover of a single mirrored database?
I have 3 mirrored databases on a single instance of sqlserver2008-R2 in a high safety with automatic failover config. Is there a way to trigger automatic failover of just 1 database?
I want to ...
- 209
6
votes
1
answer
2k
views
Transaction log growing on a mirrored principal
I have a pair of SQL Server 2008 R2 servers hosting a synchronously mirrored database with no witness. This weekend, we had to do some network maintenance so I paused the mirroring. Upon resuming, the ...
- 609
4
votes
1
answer
8k
views
Setting up Mirroring in SQL Express Edition
I know doing something like mirroring in SQL Server express edition is not possible, but can we do real-time db backup and restore and setup some automated task which acts like mirroring and keep them ...
3
votes
2
answers
1k
views
What is the best way to mirror an ASPState database?
I'm not having issues with the actual mirroring part, but because of the use of temporary tables, IIS is throwing a bit of a wobbler if a failover occurs (I'm still testing a few things, so it's me ...
- 959
2
votes
1
answer
132
views
Replace/upgrade mirrored server hardware
We are deploying new VMs for a mirrored database that is in high safety mode with automatic failover and also going from SQL Server 2008 to SQL Server 2008R2.
Most of the documentation I've come ...
0
votes
1
answer
76
views
Restrictions after you failover to an upgraded server instance
Restrictions after you failover to an upgraded server instance.
Can some one please explain this is detail? "After failing over from an earlier server instance to a SQL Server 2016 server instance, ...
0
votes
1
answer
234
views
SQL Server Mirror failover on failing storage
Recently we had an issue with a sql server 2008 r2 HA mirror. I have tried to reproduce this in a lab environment and i came to the conclusion that i am missing something OR something is not possible.
...
- 133