The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
76 views

Replication throw an error after failover mirror partner is down in SQL Server

Received an error mentioned below after failover when mirror partner is down. Error : to fail over to a database which is not configured for database mirroring. code: 22037, text: 'Invalid ...
2
votes
1answer
20 views

SQL 2012 Mirror in a Disconnected state - how do I fix it?

We had a hardware failure last night and we got our servers up and running. After logging into SSMS I find all the mirrored databases in a disconnected state. I've done some searching with ...
2
votes
0answers
59 views

SQL Server 2008 R2 - Two Files Stuck In Restoring Status

Background: SQL Server 2008 R2 mirrored and clustered. We recently failed over the databases via mirror and everything went smoothly. When it was time to do a differential backup, I got an error so I ...
2
votes
1answer
25 views

Propper way to monitor SQL Server mirror status from service or job?

We have a production DB which is in a mirror configuration. It is in synchronous high safety with automatic failover configuration. Right now we monitor it using windows service which pings it. Is ...
2
votes
0answers
23 views

Mirroring won't fail back

Got an interesting mirroring issue. I am using SQL Server 2008 R2. Server A mirrors 8 databases to Server B ideally. Right now the 8 databases are principal on Server B (otherwise healthy). When I ...
2
votes
1answer
207 views

SQL Server Mirroring and automatic failover - why don't all DBs failover to the mirror?

On SQL Server 2008 R2, I'm mirroring 20 databases on my SharePoint SQL Server with a witness, high-safety. All mirrored DBs have the default mirroring_connection_timeout = 10. And, occasionally, a ...
2
votes
1answer
38 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 ...
9
votes
0answers
91 views

Why my database mirror break down after changing file group settings from RESTRICTED_USER to MULTI_USER?

My environment is the following: VMWare 5.5 vitalized server MS Windows Server 2008R2 Enterprise domain and SQL Server 2008 R2 Enterprise. Centralized storage with fibre-channel connection. I have ...
10
votes
3answers
908 views

Best way to migrate a huge SQL Server database with low downtime over network

Problem definition Our database server needs to be transferred to an other datacenter. It runs on Microsoft SQL Server 2012 Enterprise (64-bit) and contains two databases of about 2TB and 1TB. ...
1
vote
0answers
31 views

SQL Server Mirroring Removed

Does anyone know how to tell when SQL Server mirroring was removed from a database? My log file is flooded with login failures but I can't find mention of removing of a mirror. Is there any DMV way ...
2
votes
1answer
73 views

DR option for SharePoint databases? ideas and experiences

First let me clarify that I am not looking for thoughts in terms what is the best or the bad options for a DR for SQL Server. I am just looking for for inputs from experienced people. We are running ...
0
votes
1answer
28 views

Safe delete Transaction Log in SQL Mirroring scenario

We are using SQL Server Mirroring with a witness (High Safety mode) and we see the transaction log on the Principal Server has grown around 20 GB in few weeks. I looked around on SO and google for ...
1
vote
0answers
33 views

Could not redo log record on mirror

One of my database mirrors is in the suspended state today and the error log on the mirror shows the following. Could not redo log record (338934:102862:477), for transaction ID (0:848150408), ...
3
votes
1answer
71 views

Mirror db from production to test and acceptance nightly or weekly

I have read this Easy or Schedulable way to move data from Production to Test and it seems not automated. I would like to have a daily or weekly push of my production server data to one or two ...
1
vote
2answers
86 views

SQL Server 2012 and DBM

Why would MSFT would deprecate mirroring from 2012.. I understand alwaysON will replace it but then SE users are left with nothing..no alwaysON or dbm from future releases.. Just analyzing from end ...
1
vote
0answers
17 views

Transactional publication and database mirroring considerations

I've recently taken over a project, and with it comes 2 backends. 1st is the production services backend and the 2nd is a reporting service backend. Both of which are 2008r2 instances. The production ...
3
votes
1answer
68 views

SQL Server 2012 mirror setup - how to reduce transaction log files [duplicate]

We just upgraded our Windows Server 2003\SQL Server 2005 setup to Windows Server 2012/SQL Server 2012. Both configurations have a mirror with NO witness server. On the old setup the transaction logs ...
1
vote
1answer
32 views

When I implement database mirroring in SQL server it shows an error

When I click the start mirroring button it shows the below error message. When I try to connect the mirror and witness server through management studio it's connecting and working fine. The user I am ...
4
votes
1answer
2k views

Version of Witness Server for mirroring SQL 2012

Can I use SQL 2008 R2 as a Witness Server for 2 instances of SQL 2012 Servers being mirrored?
5
votes
2answers
2k views

Mirroring in SQL Server 2012

I've got newly installed Win 2008 R2 machines, in a workgroup, in the same subnet, and of course SQL Server 2012. I allowed login with SQL Server authentication, thinking it may help with each ...
1
vote
2answers
108 views

How can I restart Database Mirroring after intentionally breaking it?

I have SQL server mirroring on two servers. I have Enterprise Edition on the primary server and Standard Edition on the secondary server. In order to verify the data on the secondary server I ...
2
votes
2answers
79 views

migrate db's - best way to mirror or replicate a full database

I would like to mirror/replicate my databases to the cloud. The cloud is setup using VPN to my actual machine. I am a bit confused by the options I have and would like to get some light into it. My ...
0
votes
0answers
28 views

Steps to stop and start SQL Mirror server instance in Amazon EC2

I have to stop and start the SQL server instance running on AWS. What are the steps that needs to be followed to get the Mirror server working again. Would the steps described here Should I pause ...
8
votes
2answers
476 views

Mirroring the Distributor

Has anyone had success with mirroring the distribution database? We have a dedicated server as a Distributor. It handles all our push replication from prod to reporting. We'd like to build an ...
0
votes
2answers
77 views

Having DB Mirroring and Replication together

Can anybody help me understand why do one go combination of Database Mirroring + Replication. Why can't I just have Database mirroring for high availability of my database. What is the need of ...
0
votes
1answer
50 views

SQL Server 2008 R2 - Moving nodes in mirrored environment

Was hoping that I would find this documented somewhere, but I've searched and searched. Finally asking the question myself: I have SQL Server 2008 R2 in a HA setup (primary/mirror/witness) I want to ...
0
votes
0answers
53 views

Backup Mirror database

I have database mirroring setup between two SQL 2012 servers in two different datacenters. For testing purposes in the "mirrored" datacenter I would like to create a working copy of the database. ...
0
votes
0answers
130 views

How to clean DBMIRROR_EVENTS_QUEUE process on broken mirror?

We setup mirror (on SQL Server 2008 R2), but it fails during the setup. After that the mirror was moved on another server. My problem is that it left some process, because on that server I see active ...
0
votes
1answer
75 views

SQL Server : Restoring database mirroring once its turned off

I was running security updates on the sql server mirror setup and I encountered split brain scenario as mentioned here Should I pause Mirroring and stop SQL Server services before running windows ...
0
votes
0answers
43 views

Changing the Service Account with SQL Server Mirroring

As the title suggests we are looking to change the service account of a SQL Server mirror implementation. I will be using the same account on all 3 servers involved in the configuration. I know each ...
6
votes
3answers
5k views

How can I inspect the security settings of a SQL Server Endpoint?

I am in the process of creating a TEST environment for our SQL Server development staff. In production we have 3 SQL Servers, SQL01 contains several databases that are mirrored to SQL02. SQL03 ...
3
votes
1answer
76 views

Microsoft SQL Server 2012 Mirrors Go Into Disconnected

I have some Microsoft SQL server 2012 mirrors, without a witness in asynchronous mode, that are sporadically going into disconnected. I am running SQL Server 2012 11.0.5058. Looking at the logs on ...
13
votes
3answers
13k views

What can cause a mirroring session to timeout then failover? SQL Server 2005

We have two production SQL Servers running SQL Server 2005 SP4 with cumulative update 3. Both servers run on physical machines that are identical. DELL PowerEdge R815 with 4 x 12 core CPUs and 512GB ...
0
votes
2answers
40 views

Does a mirroring configuration requires the database do stop receiving requests?

I want to configure a SQL Server 2012 Mirroring. I know that I have to create a full backup of the Principal server and restore it at the Mirror server. After that, I will backup the transaction log ...
0
votes
1answer
49 views

How to safely resume a SQL Server Mirroring scheme that had a expired certificate?

We have a production database with a SQL Server 2012 Mirroring scheme with three machines: Principal, Mirror, Witness. The mirroring was configured with a certificate that had only one year of expiry ...
4
votes
1answer
134 views

AlwaysOn AG - CPU limitations

I’ve been trying to find out if the same CPU limitations database mirroring has apply to Availability Groups. My guess is that the same limitations exists, given that Availability Groups was built on ...
1
vote
2answers
5k views

Best Possible Solution for Reporting Mirroring or Replication?

Hi I have SQL SERVER 2008R2 Data Centre Edition and I use SSRS and a Vendor application for reporting. I have a Reporting Server where we backup and restore everyday from Live Server to have Data ...
5
votes
1answer
341 views

Should I use Database Mirroring?

So I have the following scenario on my hands: I have a product database that runs for a specific app, all inserts into the database come in through three separate connections. Recently I have ...
4
votes
1answer
350 views

SQL Server 2008 R2 Readable Mirror

I know that SQL Server 2012 and 2014 offer AlwaysOn Availability Groups which provide this functionality, but I'm still stuck on SQL Server 2008 R2 for a while. I recently came across this AWS ...
0
votes
0answers
36 views

Database mirroring in SQL Server 2008 R2

I have problem with database mirroring. I have 2 servers on both I have installed SQL Server 2008 R2 and on both I created the same user name and password. Db mirroring is working if I use "This ...
1
vote
2answers
433 views

Detecting and fixing database corruption on SQL Server mirrored database

I’m new to my current company and we have a System Administrator but no DBA. In the past I’ve taken care of DBA related issues at other companies. I’ve run into and corrected database corruption in ...
1
vote
1answer
59 views

What precautions to take when moving a mirrored server

I have a SQL Server 2008 R2 mirror setup running in high safety with automatic failover (synchronous, witness). Over two different nights, the mirror and the primary will be shut down and re-racked. ...
1
vote
0answers
134 views

Set up sql server db mirror specifying IP address for mirroring_partner_instance

Ok. I run: ALTER DATABASE DbName SET PARTNER = 'tcp://10.0.0.0:5022' Command completed succesfully Then run SELECT DB_NAME(database_id) AS 'DatabaseName', mirroring_partner_instance FROM ...
7
votes
1answer
246 views

Enabling TDE without breaking existing mirror

I've been trying to enable TDE in a mirrored SQL Server 2008 R2 configuration. Enabling TDE is not so difficult, though when I enable TDE on the principal, the mirror database goes in to a suspended ...
1
vote
0answers
83 views

Why database replication fails when database mirroring is broken?

I'm trying to understand what effect database mirroring can have on replication in SQL Server 2008. Here is current environment: (don't ask me why it was done this way or to change it) Server A: SQL ...
3
votes
1answer
115 views

Effects of turning the transaction safety OFF

I am considering to turn off the transaction safety to maximize the performance. Before that i am interested in finding the current status of transaction safety. Is there any command that we can get ...
0
votes
0answers
386 views

SQL Server: mirroring several tables in different databases

I want to keep several tables in two different databases mirrored. Both databases are within the same server, and both are SQL Server dbs. This mirroring only affects the data they contain, not the ...
0
votes
0answers
30 views

SQLAnywhere: ODBC and Database mirroring

I'm tying to setup the correct way to connect to a mirrored database via ODBC. Usually a connection string like (taken from tutorial) ...
4
votes
1answer
124 views

What data gets passed between mirroring principal and secondary?

We are trying to figure out which of the below statements is correct when talking about SQL Server mirroring: The master database server executes the query, and takes the resulting transactions and ...
3
votes
2answers
366 views

What happens in this strange SQL Server Mirroring situation?

Let's assume that two SQL Server instances (S1 and S2) are in synchronous mirroring or in a synchronous Availability Group. Now the following happens: A write happens on S1 and transaction commit is ...