April 19, 2018 at 9:11 am
Hi Guys,
.I have a very old sql server instance. Running Sql server 2008 on Windows server 2008.
Wanted to confirm if the windows cluster is broken (purpose is to do X2V) (note: it has sql server active-active, active-passive setup), can sql server be ever available as a standalone instance ?
I did research but it says the same thing that it is not possible.
But need your opinion on this.
Thanks.
April 19, 2018 at 9:29 am
Somewhat confusing: "has ... active-active, active-passive setup". Huh, can't be both at the same time, which is it?
If A-P, I know we've undone/removed clustering and it worked fine, so overall my answer has to be Yes. I would think the same would be true of A-A, you could still run nodes separately.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
April 19, 2018 at 9:46 am
Hi Scott,
So you are saying that for existing Active - Passtive configuration if the cluster is broken SQL Server (actually in the same cluster there are two AP instances runnng) wll be available and running as a standalone machine in each node (as it has 2 sql sevices running in each node)?
Is that what you are saying?
Thanks.
April 19, 2018 at 10:59 am
I don't know about "broken", but if you "uncluster" it normally, it runs fine.
And, yes, then you have two servers each running a single, separate, independent instance.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply