faisalfarouqi (6/26/2014)
Thanks! Perry....but then you're asking me again to migrate the objects which isn't what I want to do. Basically, all I want to do is an in-place upgrade.Regards,
Faisal
There is no in-place upgrade to go from a standalone instance to a clustered instance, what you're seeking is not a supported upgrade path!!
This link shows the following points
MSDN: Upgrade a SQL Server Failover Cluster
The following scenarios are not supported:
- You cannot migrate from a stand-alone instance of SQL Server to a failover cluster.
- Add features to a failover cluster. For example, you cannot add the Database Engine to an existing Analysis Services-only failover cluster.
- You cannot downgrade a failover cluster node to a stand-alone instance.
The upgrade can be achieved very easily using the steps i outlined above (looks a lot of work, but really it isn't)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉