No announcements
-
0 VotesMaintaining Transaction Logs in SQL Server Mirroring
Hello All, We have SQL Server 2008 R2 in mirrored configuration. We have 9 databases configured in Mirroring and 3 of 9 databases are creating so much transaction ...Proposed | 3 Replies | 65 Views | Created by Ratsr - Wednesday, December 06, 2017 9:30 AM | Last reply by TiborK - Wednesday, December 06, 2017 11:39 AM
-
0 Votes
Is a combination of AlwaysOn and mirroring supported on the same SQL 2016 Std.Ed. AlwaysOn cluster?
We are migrating to AlwaysOn Basic Availability Groups on SQL Server 2016 Standard edition, but it seems as if we cannot add a database mirror for an application that does not support basic ...Unanswered | 1 Replies | 81 Views | Created by Roland_vanderKruk - Tuesday, November 28, 2017 12:55 PM | Last reply by Teige Gao - Wednesday, November 29, 2017 6:47 AM -
0 Votes
Database Mirroring between two SQL clsuters
Dears, We want to create Database mirroring between two SQL clusters. First we have one cluster that is already configured. We need to create another cluster and ...Proposed | 8 Replies | 152 Views | Created by Ros-12 - Thursday, November 23, 2017 8:30 AM | Last reply by Lin Leng - Monday, November 27, 2017 5:35 AM -
0 Votes
Mirroring database went into (mirror, Disconnected/In Recovery) status.
Hi All, In my environment, We are having SQL Server 2012 CU3 ENT Edition and have configured mirroring without witness server. Everyday during 5:30 PM to 7:00 PM ...Unanswered | 2 Replies | 110 Views | Created by Nagendra008 - Wednesday, November 22, 2017 7:56 AM | Last reply by Nagendra0088 - Thursday, November 23, 2017 4:19 AM -
1 Votes
Connection handshake failed
I am attempting to set up mirroring for the first time between two servers. The servers are on the same domain, I am using the wizard to setup mirroring, i am logged into each server using a ...Answered | 11 Replies | 30884 Views | Created by JBruyn - Thursday, October 27, 2011 8:43 PM | Last reply by Conor_Lynch - Friday, November 17, 2017 11:43 AM -
0 Votes
mirroring between sql 2012 and sql 2017
Trying to setup a mirror between a 2012R2 server running sql 2012 std and a new 2016 server running sql 2017 std as part of an upgrade. The mirroring starts but ...Answered | 4 Replies | 183 Views | Created by neildba - Sunday, November 12, 2017 9:55 PM | Last reply by Gnana Balaji Kanagaraj - Thursday, November 16, 2017 8:14 AM -
0 Votes
Database mirroring error
I have two servers DB1 and DB2. My team is configuring mirroring in between these servers, DB1 is a primary server and DB2 is a secondary server. Both of these servers are able to ping each other, ...Proposed | 2 Replies | 112 Views | Created by SMThakur - Tuesday, November 14, 2017 9:16 AM | Last reply by Satish Kumar Gajula - Tuesday, November 14, 2017 3:47 PM -
0 Votes
How to add data file to a mirrored database?
SELECT (SELECT DB_NAME(5)) AS DBName,database_id,mirroring_state_desc,mirroring_role_desc,mirroring_partner_name, mirroring_partner_instance FROM ...Discussion | 1 Replies | 260 Views | Created by BrajeshDBA - Saturday, November 11, 2017 7:52 AM | Last reply by Uri Dimant - Monday, November 13, 2017 5:03 AM -
0 Votes
Active-Passive node in Cluster and SQL Mirrored DB in un-clustered environment (all are in same domain)
I have configured active passive cluster in production environment. And we also have a dr server which we have configured with asynchronous mirroring with no witness in same domain (all ...Answered | 15 Replies | 304 Views | Created by DS150585 - Wednesday, November 01, 2017 12:07 PM | Last reply by DS150585 - Saturday, November 11, 2017 4:46 AM -
1 Votes
Best way to re-establish original mirroring configuration after a fail-over to mirror database
We are testing mirroring on SQL Server 2012 SP2 Standard Edition 64-bit. We do not have a Witness server configured. In the first scenario we tested ...Answered | 2 Replies | 151 Views | Created by CMDR Shears - Wednesday, November 08, 2017 9:52 PM | Last reply by CMDR Shears - Thursday, November 09, 2017 8:05 PM -
0 Votes
SQL 2008 High Availability Query
I have an SQL 2008 system which I was told to have two servers configured as active/standby with a VIP network configuration. Failover ClusteringDatabase MirroringLog ...Proposed | 3 Replies | 126 Views | Created by EvanCamilleri - Thursday, November 09, 2017 8:20 AM | Last reply by Lin Leng - Thursday, November 09, 2017 9:45 AM -
1 Votes
How to replace the default generated MS SQL 1024 bit certificate by own generated 2048 bit certificate for mirroring
We have a project installed MS SQL 2016 with Mirroring setup. The self generated certificate was found to be only 1024 bit and there is no options during the setup to change it. The system did not ...Answered | 1 Replies | 131 Views | Created by KristWong - Tuesday, November 07, 2017 3:20 PM | Last reply by Hilary Cotter - Tuesday, November 07, 2017 3:34 PM -
0 Votes
Connecting to Secondary SQL server , If primary SQL Server is down
Thanks in advance, I have different windows + web applications which are connected to a SQL Server which is hosted in the web, I wanted to establish a secondary SQL server to ...Proposed | 3 Replies | 241 Views | Created by Mirza Rahman - Sunday, November 05, 2017 11:47 AM | Last reply by Alex Bykovskyi - Monday, November 06, 2017 4:42 PM -
0 Votes
how to find separate ping time for each database in mirroring in sql server
The issue is that there is a separate ping for each database, not one for all. So some are successful and some fail.Unanswered | 9 Replies | 262 Views | Created by Dix14 - Monday, October 09, 2017 7:49 AM | Last reply by Tom Phillips - Tuesday, October 31, 2017 11:59 AM -
0 Votes
Memory usage is very high
I have 28GB on my server and set sql server max memory to 20GB, memory usage is 77%. Is this because of the sql max memory? Microsoft SQL 2014 Standard edition ...Proposed | 3 Replies | 184 Views | Created by Sun i ta - Monday, October 30, 2017 5:30 AM | Last reply by Hannah Yu - Tuesday, October 31, 2017 2:30 AM -
1 Votes
How to Mannage SQL server job in mirroring in the event of failure..
Hi, we configured mirroring for a client databases. this is a dedicated server for that client. we have some set of jobs need to run on primary. now i have a problem how to transfer ...Proposed | 3 Replies | 162 Views | Created by bhushayya - Friday, October 27, 2017 12:04 PM | Last reply by pituach - Monday, October 30, 2017 12:53 PM -
0 Votes
Restore Azure Database using SQL Server Management Studio and .bak file
Hello, I have database backup file which is .bak file and I want to restore this database on Azure. As I am beginner to Azure and unable to find way to restore, ...Proposed | 1 Replies | 166 Views | Created by saurabh 2k - Sunday, October 29, 2017 2:35 PM | Last reply by baraczof - Sunday, October 29, 2017 10:32 PM -
4 Votes
Recommended process for patching windows server when using SQL Server mirroring
We are setting up 3 nodes with 2008 R2 SQL Server instances - one is a principal instance, one is a mirror, and one is a witness. We wish to use this configuration to increase ...Answered | 6 Replies | 6785 Views | Created by pellet88 - Thursday, June 20, 2013 11:19 AM | Last reply by Robert L Davis - Sunday, October 29, 2017 1:42 PM -
0 Votes
SQL Mirroring issues-2014- ENDPOINT or any other areas?
Opted to SQL Mirroring as HA solution because of the application to vendor support limitations. Current set up is 2008 R2 with mirroring as HA. Upgrading to 2014 and I have attempted to build ...Answered | 2 Replies | 240 Views | Created by Kpvuppala - Sunday, October 15, 2017 3:52 AM | Last reply by Kpvuppala - Thursday, October 26, 2017 4:42 PM -
0 Votes
Connection handshake failed. The certificate used by the peer is invalid due to the following reason: Certificate not found. State 89.
Hi experts, I know this is a common issue and I have followed the procedure: "Example: Setting Up Database Mirroring Using Certificates (Transact-SQL)" twice but I ...Answered | 3 Replies | 216 Views | Created by dennislee124 - Monday, October 23, 2017 2:19 AM | Last reply by Lin Leng - Tuesday, October 24, 2017 7:32 AM - Items 1 to 20 of 2662 Next ›
No announcements
