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

learn more… | top users | synonyms

1
vote
1answer
78 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 ...
1
vote
1answer
146 views

Snapshotting Database Tables

I have a reporting database (in SQL Server) that takes nightly snapshots of the production data (Oracle) for users to query against for the next day, but now the requirement is getting to be that they ...
0
votes
1answer
286 views

Troubleshooting Mirroring Configuration

I am configuring database mirroring on SQL Server 2012. After configuration I am getting the following error when attempting to start the mirroring session: tcp server cannot be reached or does ...
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 ...
1
vote
0answers
10 views

Change Data Capture not running when Mirror is Suspended

We have 2 SQL 2012 SP2 Enterprise servers that have some mirrored databases. One of these databases also has CDC enabled on a number of tables so that we can run some business logic when there are ...
1
vote
0answers
40 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 ...
1
vote
0answers
30 views

What happens if SQL Server mirroring fails over and during synchronisation?

I have two sql boxes, one primary and one mirror. The mirror stopped synchronising last night for about 12 hours and so now the primary is transferring about 25GB of logs that built up. However ...
1
vote
0answers
29 views

Data mirroring suggestions

On my test environment, I have a SQL 2012 2-node physical cluster that accesses a common iSCSI storage on a separate Windows Server 2012 box. What options are there if I want to backup this storage to ...
0
votes
0answers
20 views

Any way of checking mirroring monitoring whilst the primary is unavailable?

I have two sql boxes, one primary and one mirror. The mirror stopped synchronising last night for about 12 hours and so now the primary is transferring about 25GB of logs that built up. It's now ...
0
votes
0answers
46 views

Mirror database on same server instance for better read performance?

I am developing a somewhat big web application, which uses data which is aggregated using a crawler. The crawler is constantly writing to the database and updates many tables at the same time. For the ...
0
votes
0answers
64 views

Transaction log backups during index maintenance

We have a database with large and complex files and fragmented indexes. The environment is SQL 2008 Full recovery model and Mirrored which limits me to reorganizing. The backup strategy is Full ...
0
votes
0answers
34 views

SQL Server: mirroring several tables in different databases

I want to keep several tables in two different databases mirrored. Both databases are within the same server, and both are SQL Server dbs. This mirroring only affects the data they contain, not the ...
0
votes
0answers
113 views

SQL Server Mirroring send/receive ack time not normal

I have a problem that arises during the performance test by microsoft team in my client. The report that is given to us provide information about whether or not a parameter is good based on the Object ...