No announcements
Found 1936571 threads
-
0 Voteshow to set up monitoring of SQL mirror failover?
In addition, please see if the following MP helps: SQL Server Mirroring MP Update V ...Answered | 6 Replies | 1887 Views | Created by kimdav111 - Wednesday, October 10, 2012 3:51 PM | Last reply by Nicholas Li - Thursday, October 11, 2012 3:49 AM
-
1 Votes
SQL to check failover history for mirroring.
You can either use sp_dbmmonitorresults or you can use the Database Mirroring History in the mirroring monitor page to check this information.Answered | 1 Replies | 1878 Views | Created by PPQatar - Tuesday, August 25, 2015 9:42 AM | Last reply by Ashwin Menon - Tuesday, August 25, 2015 10:26 AM -
0 Votes
Lync 2013 Enterprise - Setting up SQL mirroring for Lync Pool FE servers, Persistent Chat and Monitoring/archiving
All of the databases can be supported by the same SQL Server or Mirror set.Answered | 5 Replies | 9805 Views | Created by moh10ly - Friday, May 10, 2013 12:15 PM | Last reply by Kent-Huang - Tuesday, May 14, 2013 2:16 AM -
1 Votes
How to monitor SQL 2012 database mirroring in SCOM 2012?
Unfortunately, the latest MP's mirroring monitoring capabilities are specifically for 2008 versions of SQL ONLY: Support for ...Answered | 4 Replies | 6725 Views | Created by MJ2012 - Wednesday, July 10, 2013 11:16 AM | Last reply by Mudpotz - Tuesday, October 8, 2013 8:58 PM -
1 Votes
How to set up SCOM alert on SQL Server cluster node failover
I've been trying to figure out how to monitor for group owner changes as well.Answered | 10 Replies | 17566 Views | Created by Marios Philippopoulos - Wednesday, November 3, 2010 7:33 PM | Last reply by Krishna N - Thursday, September 22, 2011 4:14 PM -
0 Votes
Mirroring / Failover
Just curious, please share SQL Server versions to attempt to answer you specifically.Answered | 3 Replies | 1298 Views | Created by Cornelia Gibbs - Tuesday, August 16, 2016 4:10 PM | Last reply by Santosh Chandel - Tuesday, August 16, 2016 6:07 PM -
0 Votes
Setting up mirroring with different vlans
Hi VG2104, In your scenario, it is ok to set up asynchronous database mirroring between failover cluster instances across two ...Answered | 2 Replies | 1852 Views | Created by VG2014 - Tuesday, September 15, 2015 7:55 PM | Last reply by PradyothanaDP - Wednesday, September 16, 2015 6:28 AM -
0 Votes
Mirroring monitoring
0 = Suspended 1 = Disconnected 2 = Synchronizing 3 = Pending Failover 4 = ...Answered | 4 Replies | 8714 Views | Created by rmd.jilan - Wednesday, November 10, 2010 2:10 PM | Last reply by Ramakrishna Pittu - Wednesday, November 17, 2010 1:20 PM -
0 Votes
How to deal with replication when a mirroring failover happens
Hi Alan, When a mirroring failover happens, we can configure that there is also a failover in the replication.Answered | 1 Replies | 1263 Views | Created by anaylor01 - Saturday, January 24, 2015 8:54 AM | Last reply by Lydia Zhang - Monday, January 26, 2015 6:13 AM -
1 Votes
DB Mirroring - Failover Scenarios
Venkat, The timeout settings are used to as a standard waiting time for the mirror and witness.Answered | 9 Replies | 13252 Views | Created by venkatramani1983 - Tuesday, August 9, 2011 2:15 AM | Last reply by M.SUN - Thursday, August 11, 2011 5:40 AM -
0 Votes
Monitoring Mirroring SQL Server 2008R2
If you can get the funding, then think about investing in RedGate SQL Monitor.Answered | 5 Replies | 4073 Views | Created by Kalyan Chakravarthi (MCP) - Monday, March 18, 2013 9:01 AM | Last reply by Tim Hidalgo_ - Friday, March 22, 2013 3:43 PM -
0 Votes
Failover in mirror
Failover Partner keyword not supported in .NET 1.0 or 1.1.Answered | 1 Replies | 1342 Views | Created by Dave Kozlowski - Wednesday, May 14, 2014 4:06 PM | Last reply by Prashanth Jayaram - Wednesday, May 14, 2014 7:04 PM -
2 Votes
DB mirroring - Manual failover with witness
You can use Mirroring Monitor to help you monitor you mirroring condition.Answered | 5 Replies | 1775 Views | Created by MandarAlawani - Friday, February 14, 2014 6:17 AM | Last reply by SQLZealots - Friday, February 14, 2014 10:23 AM -
0 Votes
How to failover database mirror in high performace model?
Hi, In SQL Server database mirroring, the high-performance mode uses asynchronous operations between the principal server and the ...Answered | 4 Replies | 4996 Views | Created by Wison-Ho - Monday, April 19, 2010 1:39 AM | Last reply by Jonathan Kehayias - Tuesday, April 20, 2010 4:51 AM -
0 Votes
Does Mirroring keep both databases up to date for failover purposes?
You will need three instances of SQL Server, One will hosts the Principal Database, one will hosts the Mirror Database and the third instance will be the Witness instance ...Answered | 6 Replies | 8399 Views | Created by TheSQLNewb - Friday, August 27, 2010 12:42 PM | Last reply by Uri Dimant - Tuesday, August 31, 2010 5:40 AM -
2 Votes
How can do manual failover in mirroring??
Principal available - Run below command on principal ALTER DATABASE dbName SET PARTNER FAILOVER 2.Answered | 3 Replies | 5768 Views | Created by Sivamanikanta P - Friday, May 4, 2012 1:15 PM | Last reply by RamJaddu - Friday, May 4, 2012 4:43 PM -
2 Votes
Mirroring or failover cluster better?
If you can't use the failover partner in the connection string, you could try redirecting your principal server's DNS record to the mirror site.Answered | 5 Replies | 1411 Views | Created by Thomas A Thomas - Sunday, October 6, 2013 3:17 PM | Last reply by Andrew Bainbridge - Monday, October 7, 2013 12:38 PM -
0 Votes
Failover errors in mirroring
The token is "failover partner" not "partnet".Answered | 3 Replies | 1461 Views | Created by Dave Kozlowski - Tuesday, May 13, 2014 10:48 AM | Last reply by Tom Phillips - Tuesday, May 13, 2014 2:14 PM -
0 Votes
What caused the failover in databases mirroring...how to find the cause
Yep, also have you configure monitoring for mirroring?Answered | 1 Replies | 5255 Views | Created by Gurbir Singh Rataul - Thursday, October 20, 2011 8:11 PM | Last reply by Uri Dimant - Sunday, October 23, 2011 10:54 AM -
0 Votes
Problem in Setting up Mirroring
Hi Friends, I am having small problem setting up the database mirroring.Answered | 7 Replies | 15595 Views | Created by Gopal425 - Tuesday, December 6, 2011 11:11 PM | Last reply by SNOOPY1979 - Monday, April 13, 2020 11:08 PM - Items 1 to 20 of 1936571 Next ›
No announcements
