All Questions
Tagged with sql-server-2008-r2 mirroring
56 questions
2
votes
2
answers
264
views
Impact of using mirroring to migrate between SQL Server 2005 and SQL Server 2008 R2
I've got a DB which sits on a machine (SQL Server 2005) due for replacement very soon.
I'm planning on having the database mirrored to the replacement machine (SQL Server 2008 R2) so that when the ...
- 430
12
votes
2
answers
11k
views
How to create an Event Notification that runs a Job/procedure when mirroring state changes
I'm asking this question in the sequence of this one Can I send a string over TCP using T-SQL?
Remus Rusanu exposes what it seems to be an optimal solution for my problem, but... I'm too immature to ...
- 791
10
votes
6
answers
27k
views
Reconnect mirroring server SQL Server 2008 R2
The failover server has status (Mirror, Disconnected, In recovery) and principal server has status (Principal, Disconnected).
What is the process to reconnect these servers?
andyange
2
votes
2
answers
214
views
In SQL Server 2008R2 Will currently deployed applications still work if I turn on Mirroring without changing connection strings?
I've googled a great deal, and can't come up with an answer to this.
In SQL Server 2008R2 will currently deployed applications (Asp.Net, .Net Smart Client) still work (with a connection string ...
- 123
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
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