Windows Vista Tips

Windows Vista Tips > Newsgroups > Windows Server > Clustering > SQL DB on Windows cluster

Reply
Thread Tools Display Modes

SQL DB on Windows cluster

 
 
DD
Guest
Posts: n/a

 
      01-28-2010
we would like tO setup the SQL DB using windows cluster, is it a must to have
external storage ?

the 2 server have Raid 5 configure.
 
Reply With Quote
 
 
 
 
RCan
Guest
Posts: n/a

 
      01-28-2010
yes - shared storage is a must when you make an Microsoft SQL clusters DB
highly available :
http://msdn.microsoft.com/en-ca/library/ms189134.aspx
http://msdn.microsoft.com/en-us/library/ms143506.aspx

regards
Ramazan

"DD" <> wrote in message
news:97A9186B-10C6-4DA6-8A03-...
> we would like tO setup the SQL DB using windows cluster, is it a must to
> have
> external storage ?
>
> the 2 server have Raid 5 configure.


 
Reply With Quote
 
 
 
 
RCan
Guest
Posts: n/a

 
      01-29-2010
Thats absolutely correct for multisite cluster implementations but a
"classic" single site cluster requires still shared storage.

Sorry but I'm not 100% sure here that datakeeper is the ONLY 1 supported
solution for multisite clustering/SAN replications. There are some vendors
which are offering great products... But yes, steeleye is doing here also an
great job here.... :-)

Regards
Ramazan

"daveberm" <> wrote in message
news:598b3c2c-6ffa-4451-a800-...
> On Jan 28, 4:21 am, DD <D...@discussions.microsoft.com> wrote:
>> we would like tO setup the SQL DB using windows cluster, is it a must to
>> have
>> external storage ?
>>
>> the 2 server have Raid 5 configure.

>
> No, shared storage is not required. SQL Server multi-site clusters
> rely on 3rd party replication technology to do clustering without
> shared storage.
>
> http://www.microsoft.com/windowsserv...multisite.aspx
>
> In your case, you would want to look at SteelEye DataKeeper Cluster
> Edition, the only "Certified for Windows Server 2008" host based multi-
> site cluster replication solution that integrates with failover
> clustering. DataKeeper will allow you to use the existing storage
> inside of your servers. There are other options, but they require the
> purchase of additional storage arrays from EMC or HP along with their
> replication software and cluster extensions.
>
> Here is a step-by-step article that describes the SQL Server
> configuration using no external storage.
>
> http://clusteringformeremortals.com/...%80%93-part-3/
>
> Hope that helps!
>
> Dave Bermingham
> Director of Product Management
> www.steeleye.com
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows 2008 cluster for SQL server 2005 cluster Roger Clustering 2 05-21-2008 04:46 AM
Our high end SQL server cluster is maxed out, how else to expand? Will it help to move tables off of the cluster onto other clusters or will that just create processing bottleneck on the cluster running SQL server? Daniel Clustering 1 07-23-2007 11:10 AM
Our high end SQL server cluster is maxed out, how else to expand? Will it help to move tables off of the cluster onto other clusters or will that just create processing bottleneck on the cluster running SQL server? Daniel Windows Server 1 07-20-2007 09:25 PM
Our high end SQL server cluster is maxed out, how else to expand? Will it help to move tables off of the cluster onto other clusters or will that just create processing bottleneck on the cluster running SQL server? Daniel Server Networking 0 07-20-2007 07:02 PM
Windows 2003 2 Node Cluster, AD running on Cluster Nodes and SQL 2 Brian Clustering 3 03-11-2006 01:46 AM