SQL 2005 Clustering

[chpretorius]

Hi

I am quite new to clustering. I would like to find out if it is possible to cluster SQL 2005 without any shared storage?

Thanks

C

 

[mrdenny]

No. All clustering using Microsft cluster service requires shared storage.

To get a high availability option within SQL Server 2005 without shared storage you should need to look at database mirroring or log shipping.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[WhoKilledKenny]

When you say no shared storage, it sounds like you want to build this for testing?

Suggestion would be to look at VMWare Server:

http://vmware.com/products/server/

Or Microsoft's Virtualization product.

VMWare server is free, not sure about Microsoft's.

This will allow you to build a cluster environment with shared virtual disks.

Jesse Hamrick

http://www.powershellpro.com