Question about clustering a shared storage for database file on SQL Server 2016

Question

Question about clustering a shared storage for database file on SQL Server 2016

luisalfonso70

SSC-Addicted

Points: 410
More actions
August 12, 2016 at 8:15 pm

#316159

Hello, I've read about the options for failover cluster on SQL Server 2016, so if I want to have high availability with my SQL Server I've to:
1. Create a shared storage on server 1
2. Install SQL server on servers 2 and 3
3. Create the failover cluster
This scenario will work if either servers 2 or 3 fails, so the other server still running and there is no interruption, but what if the server 1 with the shared storage fails??? :O
so hope someone can help me to answer this questions:
1. Can I create a cluster on the server 1 with the shared storage?
2. I wish to minimize the time for a recovery in the event of a server fail on 1, so what its the best configuration?
Thanks alot.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Failover clustering has a single point of failure - the storage. It's designed to protect against hardware failures of the machines (the shared storage is more commonly a SAN or NAS than another server)

If that's no acceptable, have you considered Availability Groups?

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

luisalfonso70 SSC-Addicted Points: 410 More actions · Answer 2

Thanks x the reply. Do you please recommend me some tutorial or literature about that groups?

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Sure. Start with google's first 10 results. Once you've got though that, post any questions you stuill have.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

luisalfonso70 (8/12/2016)
Hello, I've read about the options for failover cluster on SQL Server 2016, so if I want to have high availability with my SQL Server I've to:
1. Create a shared storage on server 1
2. Install SQL server on servers 2 and 3
3. Create the failover cluster
This scenario will work if either servers 2 or 3 fails, so the other server still running and there is no interruption, but what if the server 1 with the shared storage fails??? :O

Are you planning for a failover cluster instance or Availability groups?

A failover cluster instance will require shared storage, the correct order for above will be

1. Add shared storage on server 1, 2 and 3

2. Create the failover cluster

3. Install SQL server on servers 1, 2 and 3

luisalfonso70 (8/12/2016)
so hope someone can help me to answer this questions:
1. Can I create a cluster on the server 1 with the shared storage?
2. I wish to minimize the time for a recovery in the event of a server fail on 1, so what its the best configuration?
Thanks alot.

See my stairway to AlwaysOn starting at this link

http://www.sqlservercentral.com/stairway/112556/[/url]

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉