which HA options fit for multiple databases

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)

which HA options fit for multiple databases

Author

Topic

saurabh811
Starting Member

33 Posts

Posted - 2008-04-01 : 13:51:20

Hi All
database: sql server 2005 enterprise edition
OS: windows server 2003
i have production database that contains 24 databases.
i want to know which HA option is perfect for my enviorment.
bcz i think database mirroring is not suitable for multiple database on single server.pls give me your suggestions and advice..its really appreciate.

thanks
saurabh

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-01 : 13:57:38

Database Mirroring works fine for multiple databases. Why do you think otherwise?

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

saurabh811
Starting Member

33 Posts

Posted - 2008-04-01 : 14:04:09

thks tara,
let me know,is it automatic fail over possible in multiple databases?? how it works??
i mean what happen if one of my database go down???
bcz in my case i have multiple databases on one server and multiple application use multiple datbases.
can you explain in detail pls...
thanks
saurabh

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-01 : 14:06:47

Its better to have 64-bit platform if you are Mirroring 24 databases. Mirroring works fine but if any apps are pointing to two database then your application cannot redirect to 2 servers at same time (infact 1 databases failsover to mirror server while other remain in primary). Also cross databases queries and linked server becomes issues when database failsover .

saurabh811
Starting Member

33 Posts

Posted - 2008-04-01 : 14:14:44

thanks sodeep,
i have 64 bit platform.but again apps pointing to two database at same time.so failover doesnt work,right..
so what you think what is best HA options for my enviorment...i am thinking abt log shipping...give me your thoughts..
thanks
saurabh

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-01 : 14:21:28

Log shipping,Replication is not HA option. They are Warm/standy option.Clustering will be good option for your but it doesn't care about single database corruption.

Take a look about Peer-to-Peer Replication which is supported in ET edition.

saurabh811
Starting Member

33 Posts

Posted - 2008-04-01 : 14:26:07

i know that log shipping is not HA option,but i am looking close alternate to database mirroring.let me find out more about clustering.anyway thanks,

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-01 : 22:59:31

>> multiple application use multiple datbases

You mean single app uses multiple dbs or have multiple apps each of them uses single db? Anyway, mirrored db is not accessible. So db mirroring may not work for you if app needs access both servers at same time.

saurabh811
Starting Member

33 Posts

Posted - 2008-04-02 : 11:26:57

thanks all..
i find out best option for my database.i am going for failover cluster.if any one have more detail about fail over cluster then pls pass on this forum.i do have white paper from microsoft.
bcz database mirroring is good option at database level but failover cluster is grate option at instance level..thanks all

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources