Questions tagged [mirroring]

For questions about database mirroring - a technology used to create and maintain an exact copy of a database, synchronously or asynchronously.

Filter by
Sorted by
Tagged with
26 votes
2 answers
20k 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. ...
Val F.'s user avatar
  • 363
23 votes
2 answers
24k views

What can cause a mirroring session to timeout then failover?

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 (...
Hannah Vernon's user avatar
  • 70k
13 votes
1 answer
30k views

Mirroring - Server network address cannot be reached

I have SQL Server 2008 R2 Installed. It contains three instances. Default (MSSQLServer) First Instance Second Instance All these are Log On as Network Service.. Default Instance is Principal ...
testing's user avatar
  • 271
12 votes
2 answers
10k views

How to create an Event Notification that runs a Job/procedure when mirroring state changes

I'm asking this question in the sequence of this one Can I send a string over TCP using T-SQL? Remus Rusanu exposes what it seems to be an optimal solution for my problem, but... I'm too immature to ...
RagnaRock's user avatar
  • 781
12 votes
3 answers
7k views

SQL Server Database Mirroring is going to die. How can I guarantee high availability now?

The Database Mirroring feature of SQL Server is going to die: This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan ...
John Assymptoth's user avatar
11 votes
2 answers
2k views

If I fail over one database, do the others that share the same mirror endpoint fail over as well?

We have two databases setup for mirroring on a single SQL Server instance: a test database and a production database. Both get mirrored to another server using the exact same endpoints. If I go into ...
Rachel's user avatar
  • 8,457
11 votes
3 answers
18k 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 ...
Hannah Vernon's user avatar
  • 70k
11 votes
1 answer
6k views

Database Mirroring with TDE

I have the requirement of mirroring a few databases and also using transparent data encryption (TDE) on them as our data must be encrypted while 'at rest'. I have setup TDE on both the principal and ...
RateControl's user avatar
10 votes
6 answers
27k views

Reconnect mirroring server SQL Server 2008 R2

The failover server has status (Mirror, Disconnected, In recovery) and principal server has status (Principal, Disconnected). What is the process to reconnect these servers?
user avatar
10 votes
2 answers
25k views

What are the differences between Mirroring and Failover Clustering and when is each one recommended over the other?

What are the main differences between Mirroring and Failover Clustering? What kind of problem each one solves and in what kind of scenarios is each one recommended over the other?
ivanmp's user avatar
  • 2,323
10 votes
2 answers
1k 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 ...
sharadov's user avatar
  • 342
10 votes
2 answers
12k views

Transaction Log maintenance on Mirror database

SQL Server Version: 2008 R2 Enterprise SP2 I am trying to get a handle on our SQL Server maintenance and I came across something I think is incorrect. We have a single production instance with 3 ...
Jeremie Grund's user avatar
9 votes
1 answer
15k views

Breaking and Restoring a mirror

I have to do some maintenance on a secondary node of a mirror. Since this is the result of the site becoming slow while the mirror re-established after a brief network outage I want to be safe and ...
Zypher's user avatar
  • 193
9 votes
1 answer
17k views

Can I shrink the transaction log file on a mirror database?

This is a followup question to a previous question about why I couldn't shrink the log file on the principal database. To make a long story short, I setup database mirroring but forgot to make sure ...
Rachel's user avatar
  • 8,457
9 votes
1 answer
1k 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 ...
Bogdan Bogdanov's user avatar
8 votes
2 answers
4k views

Transaction Log and mirroring - looking for dumbest explanation possible

First of all I must admit that I struggle with concept of Transaction Log. I mean - I do understand that it is Log of all Transactions that happen on database, but when it comes to properly putting it ...
nikib3ro's user avatar
  • 183
8 votes
2 answers
1k views

Mirror log empty on primary but fine on the mirror

We have dozens of principle servers and corresponding mirrors, most are working fine, however, 1 of them is acting strange. Specifically, the sp_dbmmonitorresults proc returns all columns as NULL for ...
HeavenCore's user avatar
8 votes
3 answers
1k views

Is there an easy way to trigger automatic failover of a single mirrored database?

I have 3 mirrored databases on a single instance of sqlserver2008-R2 in a high safety with automatic failover config. Is there a way to trigger automatic failover of just 1 database? I want to ...
dat_girl's user avatar
  • 209
8 votes
2 answers
6k views

How do I shrink the physical Transaction Log file when it's the principal in a mirror?

We setup database mirroring over the weekend, and forgot to re-enable the job that backs up the transaction logs. When I came in this morning, the transaction log had ballooned to 58GB, and was taking ...
Rachel's user avatar
  • 8,457
8 votes
2 answers
1k 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 ...
John Wesley Gordon's user avatar
7 votes
2 answers
2k views

SQL Server replication for off site copy

We have our Primary SQL Servers in-house (15 primary servers at the moment (500 databases approx overall), most of the servers have hex core processors). These are mirrored to other backup servers in ...
HeavenCore's user avatar
7 votes
1 answer
922 views

Alerting on Database Mirroring Events

I am looking for the actions one must take to cause Threshold Alerts to occur for a single mirrored database on an instance of SQL Server 2008 containing multiple mirrored databases. FYI: This is ...
EngineeringSQL's user avatar
7 votes
3 answers
656 views

Should we periodically 'refresh' the mirrored copy of a SQL Server database?

When you have SQL Server mirroring set up, do you trust that your mirror database will stay the same as the primary, even after months and months of mirroring?  I know we all check the status, ...
Larry McPhillips's user avatar
7 votes
3 answers
2k 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 ...
user avatar
7 votes
1 answer
2k views

SQL Server Database Mirroring : strange client application behavior upon failover

I am putting a HA SQL server environment up based on three SQL Server 2008 R2 machines and database mirroring. I'll name them : principal.company.intra mirror.company.intra witness.company.intra ...
Alexis Stap's user avatar
6 votes
2 answers
1k views

Ola Hallengren with database mirroring

I am about to setup Ola Hallengrens database maintenance plan. We have our database mirrored and I was just wanting to know if I need to run the script on both my Sql Server instances or only the ...
Peuge's user avatar
  • 209
6 votes
3 answers
1k views

SQL Server 2008 mirrored Database with manual failover, need reporting database

Our current setup is a principal database used in production with a manual failover mirrored database for HA. I need to setup a reporting database as well. What would be the best approach? Shall I ...
davey's user avatar
  • 689
6 votes
2 answers
3k 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 ...
usr's user avatar
  • 7,330
6 votes
1 answer
248 views

SQL Server Mirroring kicks in before cluster has time to fail over

I have two clusters each with two nodes configured in active/passive; the two clusters take part in a high-availability mirroring session using a separate server as the witness. When a node fails in ...
Mr.Brownstone's user avatar
6 votes
3 answers
18k views

Mirroring Databases in MySQL

Is there a way to mirror databases in MySQL? In SQL Server, you have the ability to link 2 databases in a master to master relationship. One DB will accept transactions and the transactions will be ...
Lloyd Banks's user avatar
6 votes
1 answer
2k views

Mirroring problems after removing domain

I successfully created a mirror with certificates between two servers. One of those servers was a domain controller. After removing the domain the mirror was interrupted. After hours of searching I ...
MichaelD's user avatar
  • 563
6 votes
2 answers
1k views

SQL Server Backup transaction error

Hi I am attempting to backup the transaction log file to setup mirroring in SQL Server I execute BACKUP LOG CUSTOMER TO DISK ='K:\JonDB\CUSTOMER.trn' WITH INIT GO And I receive Processed 6587361 ...
user avatar
6 votes
1 answer
2k views

Should I pause mirroring when I reboot the witness server?

So I know that when patching the two main database servers (SQL Server for the record) you do the mirror, failover and then when it's all caught up do the new mirror, but what about the witness box? ...
Piers Karsenbarg's user avatar
6 votes
2 answers
7k 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 ...
James's user avatar
  • 469
6 votes
2 answers
5k 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 ...
Gabriel Brooks's user avatar
6 votes
1 answer
257 views

Retrieving cached plans fails due to cached objects of database Mirror

I'm trying to retrieve cached execution plans for a specific database object, but this fails because of cached plans which belong to a mirrored database in MIRROR state. The below query, without any ...
user avatar
6 votes
3 answers
2k views

Recommended mirroring alternative?

SETUP 2 Amazon EC2 SQL 2014 servers in different availability regions. Synchronous mirroring S3 for archiving full backups & logs at night Right now for simplicity, nightly full compressed ...
sheldonhull's user avatar
6 votes
1 answer
2k views

Transaction log growing on a mirrored principal

I have a pair of SQL Server 2008 R2 servers hosting a synchronously mirrored database with no witness. This weekend, we had to do some network maintenance so I paused the mirroring. Upon resuming, the ...
sh-beta's user avatar
  • 609
6 votes
1 answer
5k views

The definition of object '[sp_name]' has changed since it was compiled on fail-over to mirror database

We have two SQL 2012 database servers configured in a mirror with a witness for automatic fail-over. Yesterday the primary server suffered a HDD degradation which triggered the fail-over, however ...
QFDev's user avatar
  • 789
5 votes
2 answers
306 views

Quickest way to migrate mirroring to AG

Scenario is this, prod is two two node FCI with mirroring (primary/disaster DC). This is working just fine. New hardware is coming and a version upgrade to SQL Server 2012 (from 2008 R2) in the form ...
pmpjr's user avatar
  • 63
5 votes
3 answers
4k views

How to reduce network latency during mirroring?

We are using SQL Server 2008 R2 Standard edition for mirroring. But we found out that network latency is too high. It takes nearly four times time to complete a transaction while mirroring is active. ...
user avatar
5 votes
5 answers
2k views

Setting up a Redundant Sql Server 2008 Configuration While Retaining High Performance and Minimal Downtime

We have a situation where we are moving to a new hosting facility and are attempting to configure our new database environment. However, none of us are formal DBA's so a lot of what we are doing is ...
Josh's user avatar
  • 673
5 votes
2 answers
5k views

Manually moving SQL instance to another node causes immediate database mirror failover

I have a two-node SQL cluster (2008 R2). Some of the databases within that SQL instance are mirrored to another server on a remote site, using the High safety with automatic failover. The mirroring ...
paulH's user avatar
  • 1,444
5 votes
1 answer
1k 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 ...
MSB's user avatar
  • 173
5 votes
1 answer
2k views

Failover scenario with principal "hard down"

My company has a failover pair of SQL Server 2005 instances, which provide database availability for a UL-licensed alarm/call center, where uptime and availability are critical for life safety. Here'...
KeithS's user avatar
  • 243
5 votes
2 answers
776 views

Reduce load off primary server by using log shipping, or mirroring, or something else?

I have previously asked the below question about LogShipping frequencies, but I think I might be approaching this problem incorrectly (LogShipping frequency) Problem I have a high volume site that I ...
duyker's user avatar
  • 197
5 votes
1 answer
2k 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 ...
Guillermo Garcia's user avatar
5 votes
2 answers
7k views

Replication of a remote MySQL database to local MySQL database

I'm the developer of my employers corporate private website, a HTML5/PHP/CSS powered site for company reports etc. The site, hosted on a shared hosting package, connects to a remote read-only MySQL DB ...
user avatar
5 votes
1 answer
3k views

SQL Server ODBC Mirror/Failover Partner

Background/Context We are in the process of moving our SQL Server 2000 databases to a mirrored SQL Server 2008 R2 server with a witness and automatic failover. We have both .Net and Access ...
Mike S.'s user avatar
  • 53
5 votes
1 answer
562 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 ...
Tensigh's user avatar
  • 225

1
2 3 4 5
8