Can refer to disks in a RAID-1 configuration, or low-latency database replication strategies.
9
votes
3answers
3k 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
187 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
4k 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
2answers
1k 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 ...
6
votes
1answer
348 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
1answer
385 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
93 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
3answers
975 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
3answers
44 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. ...
4
votes
1answer
511 views
Mirroring - Server network address cannot be reached
I have SQL Server 2008 R2 Installed. It contains three instances.
Default (MSSQLServer)
FirstInstance
SecondInstance
All these are Log On as Network Service..
Default Instance is Principa ...
4
votes
2answers
487 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
535 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
133 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 ...
4
votes
2answers
899 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 ...
3
votes
2answers
438 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
136 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
153 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 ...
3
votes
3answers
451 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
1answer
297 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
148 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
98 views
Create incremental/differential backups in ProgressDB
Is there a way to create incremental/differential backups in ProgressDB?
3
votes
1answer
122 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
331 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 ...
2
votes
5answers
1k 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
2k 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
1k 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?
2
votes
2answers
342 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
97 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
303 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
597 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
2k 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
256 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
141 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
1answer
158 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
2answers
81 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
1answer
455 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, ...
2
votes
1answer
559 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 ...
2
votes
0answers
1k 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?
1
vote
3answers
2k 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
229 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
266 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
154 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.
1
vote
2answers
145 views
In SQL Server 2008R2 Will currently deployed applications still work if I turn on Mirroring without changing connection strings?
I've googled a great deal, and can't come up with an answer to this.
In SQL Server 2008R2 will currently deployed applications (Asp.Net, .Net Smart Client) still work (with a connection string ...
1
vote
2answers
158 views
Merge Replicate and Mirrors
I am preparing some scripts to setup merge replication in our production environment.
After completing the export from UAT, I've come across something that doesn't appear like it would work in the ...
1
vote
1answer
746 views
Can I check if a Mirror database was synchronized when the principal died?
having 2 machines, one being the principal and the second one as a mirror in case of failure of the 1st one. without witness but in High Safety mode
Is any way to check if the mirror DB was ...
1
vote
1answer
68 views
How to test mirroring with a single Microsoft SQL Server license?
I want to test mirroring in Microsoft SQL Server Enterprise in order to decide if I would implement one in production. Buying another copy of SQL Server for another machine is not an alternative, ...
1
vote
1answer
212 views
Replicate/Mirror SQL Server schema to slave databases
I have a empty database called MASTERDB and around 10, or more, slave databases that are copies of the MASTERDB database.
MASTERDB will be always empty, as I only need the schema. No data is going to ...
1
vote
1answer
58 views
Can I run a Report Server and a Mirror server from a working Log Shipping secondary instance?
Our setup:
City A - Primary server for logshipping
City B - Secondary server for logshipping
Now there is a lot of data being updated from A - B.
And the server in City B is underutilized, and it ...
1
vote
1answer
86 views
Rolling changes to production databases
We're currently using Clustering to do fail over for our SQL environment.
There are two servers that use the same shared drive. The SQL database is on a shared drive. This provides OS and hardware ...
