The tag has no usage guidance.

learn more… | top users | synonyms

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
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 ...
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 ...
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
35 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), ...
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
72 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 ...
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 ...
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 ...
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 ...
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 ...
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
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 ...
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 ...
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 ...
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
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 ...
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
351 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
435 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 ...
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
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 ...
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 ...
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 ...
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 ...
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 ...
1
vote
0answers
302 views

SQL Server spending a lot of time creating sp_dbmmonitorupdate

I have an SQL Server 2008 R2 Standard with around 80 databases, 18 of which are a synchronous mirror primary. I'm having a lot of complaints about database speed lately, so I've started digging with ...
0
votes
0answers
35 views

MySQL: migration huge tables between two databases

Hello guys (and sorry for my English). I have 2 DB's - DB1 (staging) and DB2 (production), each day some contend added/changed in some tables in DB1 and should be moved to DB2. Right now it works ...
1
vote
1answer
92 views

user mapping is droped after swithing from principle server to mirror server

I have principal server:A and mirror server:B with DB Name: "DBTest" On the server A there is a username (SQL auth.) call: user1 and is mapped to "DBTest". the Same is on Server B, same username and ...
0
votes
0answers
57 views

mirroring on sql server 2012 on different windows server 2012

I have 2 servers *.203 and *.205 I have sql server 2012 on each of them I tried to make mirroring between them every thing goes successfuly but when I tried to start mirroring it gives me ...
1
vote
1answer
77 views

many Servers of SQL server 2012 needs mirroring

I have two SQL server 2012 instances and I want to configure mirroring between the 2 servers with database. My questions are: How can it automatically change host of one if the other one was dropped ...
1
vote
1answer
45 views

many Servers of SQL server 2012 needs mirroring [duplicate]

I have now simply 2 SQL Server 2012. I want to configure database mirroring between the 2 servers. My questions are: How can it automatically change host of one if the other one was dropped ? Is ...
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 ...
2
votes
0answers
488 views

SQL Server mirroring causing issues

So we have a couple of SQL Server instances involved on mirroring without witness and operating mode is asynchronous in all cases. After we set put mirroring in place, we started facing connections ...
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 ...
3
votes
1answer
95 views

SQL Server Replication w/o network connection

Is there a way to use SQL Server Replication without a network connection? My would-be publisher is an SQL Server 2005. It is on the "outside" as it is connected to my company's primary LAN, which is ...