Stack Overflow
Stack Overflow

Questions tagged [database-mirroring]

In a database mirroring setup, one or more copies of a source database are maintained on separate servers. The copies are updated as soon as the source database changes in any way, i.e. the changes are mirrored on the copies. This setup is used to ensure that when the source database server goes down for whatever reason (e.g. a system crash, a disk crash or a network disconnect), users of the database can still keep working.

131 questions
6
votes
2 answers

Segfault on 2nd connection with pyodbc to mirrored MS SQL Server

I'm facing an issue with a Python script that connects to a mirrored MS SQL server DB. It's throwing a segmentation fault when I try connecting to the DB for the second time. Both the app server and the DB instances are running on Google Compute…
Max Twardowski
  • 117
  • 1
  • 6
5
votes
1 answer

Why is MSDTC not supported when using SQL Server Mirroring & Automatic Failover?

I have an application that I would like to have support SQL Server Mirroring. However, the architecture is currently such that multiple WCF services and DB connections will be enlisted in a single MSDTC transactions, and Microsoft states that MSDTC…
Bryan Batchelder
  • 3,557
  • 19
  • 17
4
votes
1 answer

SqlServer db mirror failover with EF6 fail Principle to Mirror only

Sql server 2014, Entity framework 6.1.2, .net framework 4.5, IIS 8, DB mirror in high safety mode with no witness. I have the following connection string Data Source=A;Failover Partner=B;Initial Catalog=DB;Integrated Security=False;User…
Sleeper Smith
  • 3,122
  • 3
  • 24
  • 39
3
votes
1 answer

Don't quite understand SQL Server transaction logs

I've read up on SQL Server transaction logs, but still not entirely comfortable with how to use/manage them. I get that they are important for things like transaction rollbacks, mirroring, replication and log shipping etc. To me, they still seem…
kenwarner
  • 27,129
  • 27
  • 126
  • 170
3
votes
0 answers

error during Django 1.8 test with multiple databases

I'm moving a Django 1.8 project from a single database setup to a writer/reader setup. I ran into the issue described in Django bug 23718 but the work arounds described didn't seem to help. Has anyone run into similar issues? Relevant code segments…
Jon
  • 79
  • 5
3
votes
1 answer

SQL OLEDB provider: connection string to Failover partner

We're trying to connect to SQL with Database Mirroring enabled. We have 2 servers: DB1 (Principal) and DB2 (Mirror). We're using connection string: Provider=SQLOLEDB;Data Source=DB1;Failover…
Baufix
  • 31
  • 3
3
votes
1 answer

Change Tracking on a mirrored database in SQL Server 2012

I'm working on a datawarehouse on a SQL Server 2012 Standard. For the benefit of our ETL process I want to enable Change Tracking. This is easily done, but this server is mirrored on another SQL Server 2012. What are the consequences for the…
8x0
  • 33
  • 2
3
votes
1 answer

SSIS 2012 oledb connectionstring using mirroring

I am trying to configure a SSIS 2012 project on a couple of mirrored databases. I was hoping to be able to use the OLEDB provider, but that doesn't seem to support the Failover Partner attribute in the connectionstring. I have tried to add the keys…
Henrik Sjang Davidsen
  • 33
  • 3
3
votes
1 answer

Synchronize between an MS Access (Jet / MADB) database and PostgreSQL DB, is this possible?

Is it possible to have a MS access backend database (Microsoft JET or Access Database Engine) set up so that whenever entries are inserted/updated those changes are replicated* to a PostgreSQL database? Two-way synchronization would be nice, but one…
user1532394
2
votes
1 answer

What mechanisms are used by SQL Server 2008 Mirroring to notify a driver that the primary has failed over?

I've got a database that is mirrored using SQL 2008 Mirroring. I have a java application, running on Linux, using the Microsoft SQL type 4 JDBC drivers. I have this setup duplicated as a QA environment. On my QA environment, when I manually fail…
Matt Fellows
  • 6,442
  • 4
  • 31
  • 55
2
votes
2 answers

Can classic ASP handle SQL Server mirroring failovers?

I have a couple of "classic" ASP apps that need to connect to a SQL Server database that is using database mirroring. Can ASP handle the failover in a similar way to ASP.NET? As in if I adjust the connection string to put the failover server…
Piers Karsenbarg
  • 2,767
  • 4
  • 31
  • 59
2
votes
1 answer

FailOver causes "The underlying provider failed"

We implemented database mirroring for WCF and set up failover partner in connectionstring as following ....Data Source=10.0.13.21,1433;Failover Partner=10.0.13.31,1433; ... 10.0.13.21 - primary server 10.0.13.31 - secondary server but somehow we…
Angrest
  • 99
  • 2
  • 5
2
votes
1 answer

SQL DB Mirroring

I have two SQL 2016 servers configured in a mirror with a witness. We've been running some failover tests and every test has succeeded except the following two scenarios. Does anyone know why these scenarios wouldn't result in a…
user3241738
  • 57
  • 1
  • 6
2
votes
1 answer

The process could not connect to Subscriber 'xxxxxx'

i have configured transnational push replication from SQL Server 2014 to Azure SQL Database publisher DB is also configured for mirroring. i get The process could not connect to Subscriber 'xxxxxx' when i see in replication monitor in tab…
Raghavendra
  • 1,121
  • 4
  • 17
  • 23
2
votes
1 answer

Operation cannot be performed on database because it is involved in a database mirroring session or an availability group (Azure)

I am experiencing an intermittent issue with SQL Azure. I am copying a readonly SQL Azure database (V12) from one elastic pool into another. Once the database is copied, I set it to read/write using: $"ALTER DATABASE [{databaseName}] SET…
ASH
  • 443
  • 2
  • 7
  • 14
1
2 3
…
8 9