CODEWITHSUNDEEP
asp.netsql-server-2008
Faisal
Faisal

Reputation: 4264

Sql Server database mirroring and ASP.Net applications

With SQL Server database mirroring, do we need to take care of something in our ASP.Net applications or does it only require a connection string change in web.config?

Upvotes: 0

Views: 413

Answers (1)

Kinexus
Kinexus

Reputation: 12904

Depends on the configuration of the mirroring; as to whether you have automatic failover setup, etc.

If you have failover enabled, the connection string will stay the same as it should just point to the virtual IP of the failover using DNS or directly.

If not, you may have to change it to whichever host is active at that point.

As far as the application is concerned, it just needs to know where it gets it's data from and this is the connection string from web.config.

Upvotes: 1

Related Questions