DB Mirroring issues - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

High Availability (2005)

DB Mirroring issues

Author

Topic

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-12-19 : 17:09:44

We are indoubt whether to go for DB mirroring or Clustering . We have one instances with 30 Databases which we want to Mirror. But Problems with mirroring i have found through research is:

1) All the client applications have to be specified the connection string while participating for mirroring

2) After the automatic failover occurs and mirror switches the role of principle, we have to again specify the connection string to all the applications(Which is crazy if we have 500 applications running in that instances

3)Microsoft doesn't allow bulk-logged operations in mirroring .We have to again stop mirroring and restore the transaction log backup and then start mirroring.

So, If any Mirroring experts have any awesome idea regarding this.I would appreciate that.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-19 : 17:16:48

1. not true
2. not true plus you don't have to use automatic failover
3. I don't believe this is true either.

We use both database mirroring and clustering. We use clustering at our primary site and then asynchronously mirror all databases to our disaster recovery site, where we also have another cluster.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-12-19 : 17:21:19

Well i am talking about Automatic failover options in mirroring

1) Don't we have to give connection string[ ex: server A Failover Partner: Server B] for applications
2) Lets suppose failover occurs from Primary to mirror .How does your applications know where server to point again if next failover occurs.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-19 : 20:41:25

1. Yes.
2. App will connect to active one based on above connection string, since only one db is active in mirrored pair at any time.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources