CODEWITHSUNDEEP
.netsql-serverdatabase-mirroring
Alex M
Alex M

Reputation: 720

Using 'failover partner' property of connection string to failover to a non-mirror database

Our application needs to use a different (stripped down) version of the principal database if it becomes unavailable. The backup database will have the same structure and objects as the principal, some tables will just have less data.

Is there a way to set up the DB mirror in such a way that no real mirroring takes place but the 'failover partner' property of the .NET connection string can still be used to connect to another database without getting 'database is not configured for mirroring' error?

Thanks.

Upvotes: 0

Views: 735

Answers (2)

Dinesh
Dinesh

Reputation: 16

Or try DNS Failover i.e. swap the hostnames of Principal servers in DNS server.

Upvotes: 0

Remus Rusanu
Remus Rusanu

Reputation: 294267

No. To use database mirroring features (ie. 'failover partner' in connection string) you need to deploy database mirroring.

Obviously, if you need to fail over to a standby database if the principal is not available, then you should use... database mirroring.

Upvotes: 0

Related Questions