Can refer to disks in a RAID-1 configuration, or low-latency database replication strategies.
0
votes
2answers
27 views
Update primary SQL Server in mirrored environment using transaction logs from old environment
I'm currently migrating a large (~40gb) database to a new environment. The new environment is a HA/mirrored set up with primary, mirror and witness nodes.
I'm backing up the database in the old ...
1
vote
2answers
36 views
Databases outside of AlwaysOn availability group stuck in RESTORING status
I am testing the AlwaysOn feature of SQL Server 2012. I have 2 servers set up and can successfully create availability groups and fail them over between servers. However, any databases that DO NOT ...
0
votes
1answer
43 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 ...
2
votes
0answers
70 views
Failover only working for Classic ASP, not ASP.net
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 ...
5
votes
3answers
107 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
378 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 ...
0
votes
0answers
32 views
How to get replication from a SQL Server mirroring setup 2008 R2
I have a mirroring setup in the UK (principal, mirror,witness) which hosts a number of databases. failover is automatic for individual databases and local client connections are managed using dynamic ...
0
votes
2answers
62 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 ...
1
vote
1answer
72 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 ...
4
votes
2answers
217 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 ...
2
votes
1answer
139 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 ...
0
votes
1answer
59 views
SQL Server 2008 Mirroring
How would one start the secondary mirror instance if the principal SQL server instance went off line?
1
vote
4answers
348 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 ...
0
votes
1answer
105 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.
...
1
vote
1answer
85 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, ...
0
votes
1answer
334 views
Resuming Replication w/ Database Mirroring when Principle is unavailable
I'm trying to setup a disaster recovery scenario and I'm stuck at this particular point. Here's what I've done so far:
A) Created principal database on Server A and and mirror on Server B
...
4
votes
1answer
692 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 ...
1
vote
2answers
174 views
Is Log Shipping or Mirroring a better solution for Disaster Recovery?
I am planning an index rebuild, however my logs are prone to huge overblown sizes.
In fact I was leaning towards doing an intelligent re-indexing, but since the fragmentation levels are greater than ...
2
votes
3answers
157 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 ...
3
votes
1answer
615 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 ...
1
vote
0answers
279 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 2008R2 machines and database mirroring.
I'll name them :
principal.company.intra
mirror.company.intra
witness.company.intra
...
9
votes
3answers
4k 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 ...
1
vote
0answers
80 views
Sql Server 2008 mirroring status different for different logins
We recently had some issues with the failover on a mirrored database: the login kept failing when the primary was down.
On connecting to the database in question with the the login that was failing ...
1
vote
2answers
171 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 ...
4
votes
2answers
558 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 ...
3
votes
1answer
343 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
1answer
142 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
2answers
155 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 ...
2
votes
1answer
174 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 ...
3
votes
1answer
149 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 ...
2
votes
2answers
89 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
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?
1
vote
1answer
91 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 ...
0
votes
1answer
146 views
Database mirroring on Rackspace or Xeround
I´m trying to resolve following problem.
I have 2 application servers on Rackspace that are connected to a load balancer. Both servers must have the same applications and share the same data. ...
8
votes
2answers
212 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 ...
1
vote
1answer
163 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
0answers
70 views
Permon counters on SQL 2005 mirroring (user defined counter log file is empty)
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
1answer
210 views
How to execute some script when database starts up
I want to execute some T-sql code, when a database starts up.
the objective is to resume a session of mirroring in case the session is "suspended" when the database comes "back to life".
So I've ...
2
votes
1answer
346 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 ...
0
votes
2answers
427 views
Mirroring after restoring the database on a new machine
We've had alot of problems with one of our database servers and two days ago the call was made to change a disk and reinstall the OS. Now this server functioned as part of a mirroring setup. Basically ...
2
votes
1answer
540 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, ...
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 ...
1
vote
2answers
286 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 ...
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
2answers
149 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
1answer
802 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 ...
3
votes
1answer
103 views
Create incremental/differential backups in ProgressDB
Is there a way to create incremental/differential backups in ProgressDB?
1
vote
1answer
236 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 ...
2
votes
2answers
680 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 ...
4
votes
2answers
981 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 ...
