Yes, you can. Make sure you buy a hardware solution that is on the
clustering HCL. HP/Dell have clustered hardware for under $10,000 which
includes shared storage.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog

[quoted text, click to view]

Its not difficult at all, almost the exact same steps.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog

[quoted text, click to view]

To be able to upgrade the standalone SQL Server instance to a clustered one, you need a cluster. As Rodney pointed out, you will need a HCL certified cluster solution.

Say, you have a cluster (but say you have purchased only one node and are planning to purchase the second node after sometime) then you can install a single node Windows cluster and then a single node SQL
Server clustered instance. Whenever you add the second node, you join the second node to the cluster and run SQL Setup to include the second node.

If do not have a cluster, you can install a standalone SQL Server and when you have the cluster, install Windows cluster, followed by SQL Server clustered instance and then move the SQL dbs from the standalone
SQL Server to the clustered instance.

On a cluster, you can upgrade a standalone SQL Server instance to a clustered/virtual SQL Server instance if you had installed the program files to the local drive and the Data files to the shared drives during the
standalone SQL Server setup.

HTH,

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Hi

For cluster you need a SAN. If you don't have one, you can't build a single
node cluster, so it is a non-starter for you.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]

You can run on DAS for a 2-node cluster though SAN is typically recommended
even for 2-node clusters (for many reasons).



[quoted text, click to view]