All Questions
Tagged with sql-server-2008-r2 mirroring
56 questions
2
votes
2
answers
157
views
In a mirror, how can I keep the SQL Server Agent offline, but have it start automatically in the event of a failover on the Principal?
In this scenario there are three MS SQL servers. ServerA has a series of jobs that write data to databases on ServerB. I want to set up ServerC as a mirror of ServerA, with all the same jobs available....
- 21
2
votes
1
answer
963
views
Database Mirroring failover with CNAME
I have SERVERA and SERVERB configured for Database Mirroring starting with A as Principal and B as Mirror. I created a CNAME for SERVERA and use that in my connection string. I am not using the ...
- 1,246
1
vote
0
answers
291
views
Waiting Tasks on Mirror
I just migrated my primary's synchronous mirror to a new server and I've noticed that there are 150 to 230 waiting tasks on the mirrored instance (based on the activity monitor.) I don't recall if ...
- 1,781
1
vote
2
answers
17k
views
Database mirroring stuck in suspended mode
We have an issue with database mirroring on one of the databases on our sql instance where mirroring is suspended for almost 15 hours now.
DB is 200 GB on SQL server 2008R2 Sp3+cu with latest patched ...
- 2,210
0
votes
1
answer
2k
views
Unsent log behaviour in database mirroring
Need your suggestion on how below works.
Situation: We had unsent log on Principal stuck for almost 10 hours with unsent data around 200 GB.
Action: Paused and resumed the mirroring. This kicked of ...
- 2,210
2
votes
2
answers
49
views
Moving SQL to a hosted server
I'm in the process of moving a large (7GB-9GB) database to a hosted server. the old server uses SQL 2008 R2 and the new one is using SQL 2016. I'm trying to find the best way to reduce the downtime ...
- 23
4
votes
1
answer
8k
views
Setting up Mirroring in SQL Express Edition
I know doing something like mirroring in SQL Server express edition is not possible, but can we do real-time db backup and restore and setup some automated task which acts like mirroring and keep them ...
3
votes
3
answers
4k
views
Database with replication and mirroring stuck in LOG_BACKUP after log file shrink
Need an advice from SQL Server Experts. I'm just a developer, not a DBA, so pardon my ignorance.
My environment consists of 2 equal instances (Node1 and Node2) of SQL Server 2008 R2 x64 (10.50.4339.0)...
- 175
2
votes
2
answers
1k
views
Is SQL Server Mirroring dependent on SQL Server Agent running?
I have SQL Server mirroring set up between two 2008R2 SQL Server instances. I have multiple databases mirrored. Prior to planned failover to the backup server I want to turn off the SQL Server Agent ...
- 23
0
votes
1
answer
76
views
Restrictions after you failover to an upgraded server instance
Restrictions after you failover to an upgraded server instance.
Can some one please explain this is detail? "After failing over from an earlier server instance to a SQL Server 2016 server instance, ...
2
votes
1
answer
612
views
How to upgrade SQL Server 2008 to SQL Server 2014 servers with mirroring configured
We have two SQL Server 2008 R2 instances with mirroring configured. We want to upgrade them to SQL server 2014.
How will this upgrade effect the mirroring between the servers, and also how should I ...
0
votes
1
answer
665
views
SQL Server Mirroring disconnected for 1 of 5 mirroried DBs after initial setup completes
Environment: 2 Servers SQL 2008 R2 RTM Standard Edition, Windows Server 2008 R2 SP1 standard edition. Both servers using the same domain service account for SQL with sysadmin access and local ...
- 165
0
votes
1
answer
120
views
Syncing two databases in a redundant network architecture
I've been reading posts on here about database mirroring and it's an almost overwhelming amount of options and information, but as I'm still new to most of the SQL database scene, I was hoping to find ...
- 101
0
votes
2
answers
47
views
DB Mirroring setup?
I have done a SQL database mirroring setup. There is a Sql job which takes continues full database backup daily. Should I stop this job ?
- 181
3
votes
1
answer
454
views
False-failures when mirrored in high-safety mode without a witness
A number of DBs are mirrored in high-safety mode without a witness. I'm trying to understand what might happen in the case that a DB (or DBs) experiences a false-failure while the primary server ...
- 166
2
votes
0
answers
449
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 ...
- 91
2
votes
0
answers
321
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
1
answer
132
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 ...
4
votes
5
answers
3k
views
SQL Server 2008 R2 Mirroring issues
I have this very frustrating problem that I've been trying to figure out for almost a week now. I have two SQL Server 2008 R2 STD w/SP3 box running on Windows 2012 R2 with two instances each, Server1 ...
- 41
2
votes
0
answers
2k
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), on ...
- 21
1
vote
0
answers
23
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 ...
- 11
1
vote
1
answer
383
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 ...
- 133
2
votes
0
answers
95
views
How To Roll Back DR Transactions Without Breaking Mirror
We have a full data center DR test coming up and will need to fail over all of our SQL Server databases to the DR site. The majority (>80%) of our databases are SQL Server 2008 R2 using Database ...
0
votes
1
answer
94
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 ...
- 347
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 ...
- 469
1
vote
1
answer
196
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. ...
- 166
1
vote
0
answers
208
views
SQL Server Mirroring with Certificates
I'm struggling with setting up mirroring with the following configuration:
Server 1 running SQL Server Standard 2008 R2, Principal
Server 2 running SQL Server Standard 2008 R2, Mirror
Server 3 ...
- 133
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 ...
Dan Trainor
2
votes
1
answer
1k
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 ...
- 166
2
votes
0
answers
1k
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 ...
- 561
1
vote
1
answer
1k
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 ...
- 135
1
vote
1
answer
940
views
What is the possibility that mirroring a database will damage, corrupt, or erase either the primary or target database? [closed]
The last time my company had tried to mirror some databases, everything worked great until one morning they came in and the primary database in one of the mirroring schemes was just blank. They had ...
- 143
1
vote
1
answer
3k
views
SQL Server database Mirroring on different servers
I tried to perform SQL Server database Mirroring(with SQL Server 2008R2). And I got success to perform mirroring with "High Safety" mode.
And for that I have used three instances of SQL Server ...
- 111
2
votes
1
answer
1k
views
Mirror failure after windows updates - possible cause?
Over a dozen SQL Server mirrors had windows updates installed this morning - 2 of which developed serious faults afterwards.
The windows updates installed where:
KB2939576
KB2957189
KB2957509
...
- 786
1
vote
1
answer
492
views
Database slowdown at random times using mirroing
Our web application suffers DB query timeouts a few times a day at random times. Can you help to work out the cause, e.g. deadlocks, mirroring (disk or network), etc?
We have two identical database ...
- 215
1
vote
1
answer
1k
views
Database Mirroring and Replication in SQL Server 2008 R2
I have configured the mirroring and replication between 4 servers (A,B,C,D).i.e, Mirroring between A to B and C to D, Replication between A and C. The configuration was a success and I am able test ...
- 11
0
votes
1
answer
115
views
Can't set up mirroring for a specific database
We have several databases. All of them are mirrored. Until now, we never had issues with this.
One database had some problems, and now when we try to enable mirror again, it just stops. Message in ...
- 181
1
vote
1
answer
503
views
database mirror problem with Network Service account
I have two SQL Server 2008 R2 instances installed on same Server and the engine log on as Network Service account which is set by installation.
there is a database TestDB on both instances. I try to ...
- 145
3
votes
2
answers
19k
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 ...
- 1,970
5
votes
1
answer
965
views
Changing autogrow settings with database mirroring
Recently I changed the Autogrow settings for some of the databases on our SQL Server 2008 R2 server. These are involved in a database mirroring configuration, with the principal on SERVER1 and the ...
- 664
0
votes
1
answer
247
views
Configure SQL Server Database for High Availability & Warehousing
I have 3 DB servers (DB1, DB2 & DB3 - all on Win 2008 R2 with SQL Standard 2008 R2 in the same datacenter). Let's assume AdventureWorks as an example database.
My goal:
- Setup DB mirroring with ...
- 343
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. ...
Virappon
0
votes
2
answers
178
views
Can I use replication/mirroring to have a "Current" database and a "Full History" copy?
I have a database that is used for current operations. The amount of data is starting to get a bit to much for the applications using it.
Most of the data is older and is very rarely needed.
I am ...
- 2,540
6
votes
1
answer
259
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 ...
Koen Mevissen
2
votes
1
answer
1k
views
SQL Server 2008 R2 database mirroring - is it possible to have a secondary server for multiple primary servers?
Scenario is that I have two servers running SQL Server 2008 R2 (64-bit), let's call them DB1 and DB2. I have set up database mirroring for all the databases on these servers so that DB1 is the ...
- 61
5
votes
2
answers
6k
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 ...
- 1,620
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 ...
- 786
0
votes
1
answer
234
views
SQL Server Mirror failover on failing storage
Recently we had an issue with a sql server 2008 r2 HA mirror. I have tried to reproduce this in a lab environment and i came to the conclusion that i am missing something OR something is not possible.
...
- 133
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
...
- 106
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 ...
- 609