September 9, 2015 at 3:48 am
I think, if the above works, (from no to yes), I have all the rest of my ducks in order but you may see something I've missed.
Background:
I have a faulty set up, an instance installed by someone who didn't understand clustering, with a clustered disk resource but all databases on a local drive & isClustered set to no. My client wants it clustered but I have no test system and must do this on live. Hence my request for reassurance!
The cluster disk is set as a cluster resource
I've moved all the databases from local to this disk.
I think I just need to set isClustered to yes, (and possibly change my dump directory to be on the clustered disk) and restart.
Appreciate any feedback good or bad.
🙂
September 9, 2015 at 4:01 am
I don't think it's possible to cluster an unclustered instance like that. To avoid future problems, I think you would be best to uninstall SQL Server and reinstall as a clustered instance.
John
September 9, 2015 at 5:29 am
That's not going to be adequate. There's different stuff in master for a clustered SQL instance.
Uninstall SQL and reinstall is as a clustered instance.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2015 at 8:56 am
Ok, thanks all. Appreciate the feedback.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply