Can refer to disks in a RAID-1 configuration, or low-latency database replication strategies.

learn more… | top users | synonyms

11
votes
3answers
7k 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 ...
8
votes
2answers
3k 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 ...
8
votes
2answers
379 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 ...
7
votes
1answer
7k 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 ...
6
votes
1answer
3k 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 ...
6
votes
1answer
725 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 ...
6
votes
1answer
2k 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 principle and ...
5
votes
3answers
773 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. ...
5
votes
1answer
1k 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 ...
5
votes
1answer
519 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 ...
5
votes
1answer
448 views

Mirroring partner timeout - Not working the way advertised?

I'm testing a 2 node windows failover cluster with mirroring in high safety mode and automatic failover. My mirror is a standalone server as is the witness. All instances are 2008 R2 RTM Enterprise ...
5
votes
1answer
2k 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 ...
4
votes
2answers
4k 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?
4
votes
3answers
2k views

How to sync the data between two identical DB

The thing is I've two identical databases, one is in my localhostserver at my laptop and the other one is on the office main server. Is there any automatic way or software that can synchronize the ...
4
votes
2answers
718 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 ...
4
votes
2answers
1k 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 ...
4
votes
1answer
591 views

Impact of an Asynchronous Mirror / Full Recovery Model on Performance

For an asynchronous mirror in SQL Server 2008 R2, using the full recovery model is required. Assuming that the network and disk IO on both sides of the Mirror can keep up with the transaction logs ...
4
votes
2answers
83 views

Impact of deleting 100GB table on Mirroring

I'm about to delete a large table which is approximately 100GB in size. I'd like to understand the impact on the mirroring that's in place on this db. Can anyone confirm?
4
votes
2answers
2k views

Read-only copy of SQL Server database

We have main database, through out day we insert/update this DB through main application(windows). We have another web application which is suppose to just display content from main DB but instead we ...
4
votes
3answers
686 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 ...
3
votes
2answers
375 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 ...
3
votes
2answers
707 views

What is the best way to mirror an ASPState database?

I'm not having issues with the actual mirroring part, but because of the use of temporary tables, IIS is throwing a bit of a wobbler if a failover occurs (I'm still testing a few things, so it's me ...
3
votes
1answer
282 views

SQL Server DR, mirroring or virtualise and mirror

I have a client with a small business server 2008 Premium installation. This obviously includes SQL Server 2008 standard on a separate 2008 server. On the SQL we run several line of business ...
3
votes
1answer
334 views

How can I automatically trigger a script when my DB fails over?

I have some Windows services that I'd like to restart after a database failover but I can't find any details on triggering external actions after a failover. I'm working with SQL Server 2012 database ...
3
votes
2answers
158 views

Database Mirroring of SQL server

I have two databases that are mirrored to another server using database mirroring. The mirror server has to be down for some reason for few days. Now, the production server is having principal ...
3
votes
1answer
578 views

Best Approach for Mirroring Data from SQL Server to MySQL

I need help in regards to replicating data from a third party point-of-sale system with a SQL Server backend to a MySQL DB. Specifically, can anyone suggest a best way to mirror data from SQL ...
3
votes
2answers
244 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 ...
3
votes
1answer
1k views

SQL Server Mirroring vs 3rd party replication products such as DoubleTake

I'm charged with looking after several SQL Server instances, most of which use SQL Server mirroring to replicate data for DR purposes. I automatically script logins, roles & jobs to the mirror, ...
3
votes
1answer
151 views

Create incremental/differential backups in ProgressDB

Is there a way to create incremental/differential backups in ProgressDB?
3
votes
1answer
258 views

Transactional versus Merge Replication (Restore backup after downtime)

I have the following transactional replication setup: Windows Server 2008 with SQL Server 2008 Enterprise Server A: Master, has a database with a table, publisher Server B: Slave, subscriber ...
3
votes
1answer
352 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 ...
2
votes
5answers
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 ...
2
votes
2answers
3k views

Database mirroring - Witness only

In SQL Server 2008 R2 Express the only mirroring alternative is "Witness only", however I can't find a good explenation to what this is. I would like to have a database on a virtual server and then ...
2
votes
2answers
403 views

Database Mirroring Failure Reasons

I was wondering if there is any information on what scenarios might cause a DB Mirror to have to be recreated? I am attempting to research how sturdy the technology is and under what scenarios do we ...
2
votes
1answer
667 views

Should I use Asynchronous Mirroring?

I plan on setting up mirroring on a SQL 2012 database which is currently in production. My concern though is how much it will affect the performance of the principal database. I am using mirroring ...
2
votes
1answer
743 views

Mirroring not working after a server crash

I'm using SQL Server 2008R2. Last night, the host machine on which my mirror database was running basically went belly up. Thankfully the principle database was on a different host server and so was ...
2
votes
2answers
1k views

Manual failover error, not in correct state

i'm doing some tests to build one database with one mirror database and one witness. so far, i'm failing in the first test, I want to kill the witness, then the Main database, and then put the Mirror ...
2
votes
3answers
3k views

How to Setup SQL Server 2008 R2 Mirror

I am trying to set up SQL Server 2008 R2 mirroring but I am getting stuck with this error: An error occurred while starting mirroring. Additional Information: Alter failed for Database ...
2
votes
1answer
408 views

SQL Server 2008 Mirroring Pauses without warning

I have several databases mirroring with a witness. All 3 machines are local to our network and have generous nics. Monitoring the mirroring, it does not seem like there is a lot of network traffic. ...
2
votes
3answers
906 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 ...
2
votes
2answers
149 views

Impact of using mirroring to migrate between SQL Server 2005 and SQL Server 2008 R2

I've got a DB which sits on a machine (SQL Server 2005) due for replacement very soon. I'm planning on having the database mirrored to the replacement machine (SQL Server 2008 R2) so that when the ...
2
votes
2answers
2k views

Reconnect mirroring server SQL2008 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?
2
votes
1answer
275 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 ...
2
votes
0answers
516 views

Failover only working for Classic ASP, not ASP.net [closed]

Setup: All machines run Windows Server 2008 Enterprise SQL Server 2012 Standard (Primary) SQL Server 2012 Standard (Mirror) SQL Server 2012 Express (Witness) Root issue: Our ASP.NET application is ...
2
votes
0answers
479 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 ...
2
votes
0answers
81 views

Permon counters on SQL 2005 mirroring (user defined counter log file is empty) [closed]

I've been attempting to gather performance counters for mirroring using perfmon, over a period of time and saving this to a log file. I am able to do this without problem for general SQL Server ...
1
vote
3answers
3k views

Why are my SQL Server 2008R2 databases not mirroring?

I'm trying to set up database mirroring in SQL Server 2008R2. I've taken a full backup and a transactional backup from my principal database and I've restored both WITH NORECOVERY. However, my mirror ...
1
vote
4answers
2k views

Cannot remove Mirroring / nor restore or delete database:Error 3456 (SQL Server 2012)

I have a database that was a mirrored partner and went into suspended state. (Mirror Server was shut down). I took the principal database out of mirroring using SSMS. But now I am unable to restore ...
1
vote
2answers
434 views

Can I send a string over TCP using T-SQL?

I've set up some alerts, based on this article Now I would like the Job that is triggered by the alert to send some information to a c# application (this application, can be running in the same ...
1
vote
1answer
292 views

Mirroring multiple source databases to a single destination in SQL Server 2008

How can we maintain multiple source databases data in a single destination server database in SQL Server 2008? They all are at different networks, if that makes any difference.