September 23, 2016 at 1:48 am
Hi ,
We have PRODUCTION SQL Server (STD Edition) Active/Passive Clustering at DR server. There are two cluster disk used by SQL Server Services one for System databases and other for only User database at DR.
This two disk are dependent on SQL Services i.e disk is added in the dependent of SQL Server Services of Fail-over Management Cluster. If second cluster disk(user database) goes offline then will SQL Service stop working or there will be no affect on SQL Services at DR Active/Passive Clustering.
My doubt is if second disk goes offline for some times then SQL Services will stop or not till the 2nd cluster disk comes online
Regards,
Nikhil Desai
September 23, 2016 at 10:09 am
nikhil.desai1 (9/23/2016)
Hi ,We have PRODUCTION SQL Server (STD Edition) Active/Passive Clustering at DR server. There are two cluster disk used by SQL Server Services one for System databases and other for only User database at DR.
This two disk are dependent on SQL Services i.e disk is added in the dependent of SQL Server Services of Fail-over Management Cluster. If second cluster disk(user database) goes offline then will SQL Service stop working or there will be no affect on SQL Services at DR Active/Passive Clustering.
My doubt is if second disk goes offline for some times then SQL Services will stop or not till the 2nd cluster disk comes online
Regards,
Nikhil Desai
SQL Server itself won't go offline if the disk with the user databases fail, but the applications won't be able to communicate if the databases are offline. In WSFC, the dependent disks should fail over to the passive node all at once.
Perry Whittle has an excellent article on WSFC at http://www.sqlservercentral.com/articles/cluster/107539/. It's a part of a stairway series on AlwaysOn that I consider to be among the best I've read.
September 26, 2016 at 12:29 pm
nikhil.desai1 (9/23/2016)
Hi ,This two disk are dependent on SQL Services i.e disk is added in the dependent of SQL Server Services of Fail-over Management Cluster.
Unless I misunderstood you, I would have the dependency reversed. ie. have the SQL server services dependent on the disks.
especially for the system database disk, you would need to have disk accessible before SQL Server Services started.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply