Re: SQL Server Data Drives & Clustering w/local disk drives?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Linchi et al.,

Thanks for that info - could you or someone else recommend the best
method for me to set up these servers? I would like to have them set
up in the best way possible for data mirroring and then a manual
failover scenario - since automatic failover is not feasible.

What documents should I be looking at? Are there any good websites/
whitepapers/books on this subject - setting up two SQL2005 DB servers,
local data, best-possible-scenario failover?

Thanks
Ken


On Apr 18, 8:14 pm, Linchi Shea <LinchiS...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Specifically, is it possible to set up two machines to support
clustering/failover by using the local drives on each machine for
their data source?

No.

Linchi

"haroldsjunkm...@xxxxxxxxx" wrote:
All:

I have a 6 yr old SQL2000 server running on Win2000. I have two brand
new HP DL380G5 servers that were ditched from another project which
have six 72 GB HDD's - two mirrored for the OS, and four RAID5'd for
the data for a total of 136GB.

I have access to two licenses of SQL2005 and two Win2003 Enterprise
Edition licenses.

I do not have access to a SAN.

I have been tasked with setting up these two machines so that the data
is mirrored, and preferably, given the hardware stated - automatic
failover.

Everything I have been reading so far states that for clustering,
automatic failover, and mirroring to properly work together, that it
is necessary to store all data that your machines will access need to
be stored on a SAN.

Is there any way around this, other than:http://support.microsoft.com/kb/304261
Specifically, is it possible to set up two machines to support
clustering/failover by using the local drives on each machine for
their data source?

Thanks





.

Relevant Pages

  • Re: DB mirroring support with JDBC?
    ... Right now we're making a decision about our failover options and 2k5's mirroring is important to us. ... Will the SP1 story include having the mirror appear as single instance to the client? ... state of a running JDBC connection after a failover. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: [kde-linux] Kmail
    ... We all learn now And I thank you - My experience with mirroring is I ... If you are using SuSe the Yast partition tool will make ... RAID 1 is easy to create, however in the event you need to use the ... unless you are talking big enterprise level servers. ...
    (KDE)
  • Re: FireFox v2.0 (final) now available
    ... servers. ... They are currently mirroring these files in preparation for ... I was experimenting with IE7 ... It probably is legit, but I'd rather no risk it... ...
    (uk.sport.football.clubs.celtic)
  • Re: General help with fault tolerant, failover, load balanced configuration
    ... > I have four servers to work with. ... but totally different from a failover setup. ... > security reasons). ... You do realise that the web server is by far the weakest link in the ...
    (comp.os.linux)
  • Re: General help with fault tolerant, failover, load balanced configuration
    ... > I have four servers to work with. ... but totally different from a failover setup. ... > security reasons). ... You do realise that the web server is by far the weakest link in the ...
    (alt.linux)