No announcements
-
Sticky0VotesNew Top Support Solutions blog
Hello As part of our efforts to keep our communities informed about the most relevant content that address the top questions that we are getting in out forums and other support ...
-
Proposed0Votes
Shall we run mirroring on two different service packs.
we have setup sql server 2008 mirrored instances in cluster. we use to upgrade the server to sp3. but client was asking us to apply sp3 on one server one week and another server in another ...2 Replies | 39 Views | Created by RoyalM - 9 hours 30 minutes ago | Last reply by Tarakpatel - 8 hours 20 minutes ago -
Answered0Votes
Database Mirroring Connectivity issues
Dear Friends, I am trying to configure mirroring between two servers without witness server. Both servers have configured default ...5 Replies | 47 Views | Created by Irfan_Lhr - 13 hours 46 minutes ago | Last reply by Shanky_621 - 12 hours 38 minutes ago -
Unanswered0Votes
SQL Always On
Hi, I have installed 2 SQL servers [SQL01 & SQL02] with failover clustering and have enabled alwayson feature. Issue is I'm unable to connect to a ...3 Replies | 43 Views | Created by Nandish N M - 16 hours 22 minutes ago | Last reply by Paul stork, [MCM, MVP] - 15 hours 11 minutes ago -
Proposed1Votes
while configuring mirroing getting error : 1431
Hi Experts, while coniguring mirroring getting error 1431. pls share your ideas.2 Replies | 53 Views | Created by vijay_1234 - Wednesday, May 07, 2014 3:00 PM | Last reply by Neha Mahajan DBA - 16 hours 11 minutes ago -
Proposed0Votes
SQL 2005 mirroring - time taken to fail over?
I'm looking for an easy way to 'measure' the amount of time it takes our principal Database Server to fail over to our mirror Server in which all regular service will be ...1 Replies | 37 Views | Created by ras2a - Wednesday, May 07, 2014 2:46 PM | Last reply by Uri Dimant - Thursday, May 08, 2014 4:06 AM -
Unanswered0Votes
unable to start mirroring due to 1418 Errror!
Hi all, while starting mirroring getting error " TCp/ip does not exist " The server network address ...1 Replies | 43 Views | Created by vijay_1234 - Tuesday, May 06, 2014 3:14 PM | Last reply by Shanky_621 - Tuesday, May 06, 2014 3:55 PM -
Answered0Votes
How to resolve Error: 1418 in sql server while mirroring
Hi Support, I am trying to mirroring a database in sql server. I created a database and took a backup of it and restored on the another instance(i am using same server but ...3 Replies | 166 Views | Created by Pankaj Sharma1984 - Friday, May 02, 2014 10:04 AM | Last reply by Sofiya Li - Monday, May 05, 2014 3:51 AM -
Proposed0Votes
Database Mirroring
If database in suspect mode what is going to be happen in mirroring? will it failover?7 Replies | 155 Views | Created by S.Vijay Kumar - Wednesday, April 30, 2014 5:17 PM | Last reply by Tracy Cai - Thursday, May 01, 2014 5:34 AM -
Answered0Votes
sql
CareFor hospital is one of the popular hospitals in Scotland with branches all over the world. The hospital is known for its dedicated staff and high quality services. It has a ...2 Replies | 165 Views | Created by kuldeepbhardwaj - Tuesday, April 29, 2014 2:27 PM | Last reply by Tracy Cai - Wednesday, April 30, 2014 4:30 AM -
Answered1Votes
Error :1418
I have read all the articles regarding ERROR :1418. Still Seeing Same error : Senario:- Trying mirroring on 2 physical server. OS-windows ...6 Replies | 138 Views | Created by Naveen-DBA - Tuesday, April 22, 2014 6:10 AM | Last reply by Naveen-DBA - Tuesday, April 29, 2014 3:24 PM -
Answered0Votes
Mirror won't start
In SQL 2008 R2 Setup mirror Mirror database in recovery mode all endpoints up in started mode I can telnet to ...2 Replies | 128 Views | Created by Dave Kozlowski - Thursday, April 24, 2014 12:50 PM | Last reply by retracement - Friday, April 25, 2014 9:10 PM -
Answered0Votes
Witness disconnected to Principal but connected to Mirror
Hi, Mirroring with witness is configured in prod environment 10 days ago and works fine. Today during monitoring i have found that the witness is disconnected to ...5 Replies | 214 Views | Created by Barun Jha - Monday, April 21, 2014 7:33 AM | Last reply by Barun Jha - Tuesday, April 22, 2014 1:41 PM -
Answered0Votes
DATABASE SYNC WITH SAN
MY SQL SERVER 2005 DATABASE PICKS UP DATA FROM A SHARED DRIVE IN SAN MOUNTED ON A WIN 2003 OS SERVER HAVING IP ADDRESS A.B.C.D .NOW I HAVE TAKEN THE BACKUP OF DATA ON THIS SAN TO ANOTHER SAN MOUNTED ...1 Replies | 176 Views | Created by BOLI SHRIVASTAVA - Sunday, April 20, 2014 4:34 AM | Last reply by Uri Dimant - Sunday, April 20, 2014 2:26 PM -
Answered0Votes
Database monitoring tools in Market
Hi, I are looking for a enterprise wide tool that monitor our sql server databases and other applicaitons and also the server that we those the applications ...2 Replies | 217 Views | Created by Nag1234 - Thursday, April 17, 2014 2:51 AM | Last reply by Uri Dimant - Friday, April 18, 2014 9:22 AM -
Answered0Votes
SQL Server 2005: Monitoring Database Mirroring
Hi All, I use SQL Server 2005 with mirror enable. Are there anyway to check/monitor/verify whether all data at principal are transit to mirror serer ...6 Replies | 247 Views | Created by Pitou H - Wednesday, April 02, 2014 6:35 AM | Last reply by Shanky_621 - Wednesday, April 16, 2014 9:57 AM -
Proposed0Votes
Expected Failover times, very slow
Hi, I have a 2014 SQL Mirror setup. The mirror is set up fine with a witness and auto failover. I am failing the database over and it is very quick, it appears as principal on the ...11 Replies | 251 Views | Created by Adam Cosby - Friday, April 04, 2014 12:25 AM | Last reply by Adam Cosby - Wednesday, April 16, 2014 6:28 AM -
Answered0Votes
Server Network Address on Clustered Instance
Hi, I am looking to configure database mirroring and as part of this need to specify the server network address. The primary instance is on a 2 node cluster and the mirror data base ...2 Replies | 325 Views | Created by AllyRussell - Sunday, April 13, 2014 8:47 PM | Last reply by AllyRussell - Monday, April 14, 2014 9:53 AM -
Answered0Votes
Index maintenance
How to create index maintenance jobs in DB mirroring, as it doesn't support bulk-recovery?4 Replies | 192 Views | Created by S.Vijay Kumar - Thursday, April 10, 2014 7:15 AM | Last reply by Prashanth Jayaram - Thursday, April 10, 2014 4:35 PM -
Proposed0Votes
The database is being closed before database mirroring is fully initialized
When I issue this command: ALTER DATABASE foo set PARTNER = 'TCP://10.3.3.1:1234' I get this error message: The ...8 Replies | 15532 Views | Created by MikeBlaszczak - Tuesday, June 12, 2007 12:30 AM | Last reply by Jackey Lin - Thursday, April 10, 2014 10:53 AM -
Answered1Votes
Existing SQL Cluster: Easiest Method to Move to new Datacenter
Although there are a few questions similar to mine, I didn't find anything with these special circumstances, so I'll try a new thread: We have an existing SQL 2008 Cluster with ...1 Replies | 136 Views | Created by VintageDon - Wednesday, April 09, 2014 5:38 PM | Last reply by Sofiya Li - Thursday, April 10, 2014 9:40 AM - Items 1 to 20 of 2148 Next ›
No announcements
