ISCSI in windows 20008
Posted on 2014-08-07
I'm using rocket iscsi with a virtual disk image set up on another server. I have a production server that connects to this iscsi drive using windows 2008 iscsi initiator. When either server reboots, or loses power and the other one doesn't, it creates some wacky halt condition where the SQL server still runs, but in a very limited way (The SQL DB is not on the ISCSI volume, FYI-- nothing system related should be, no page, no index, etc) It won't run any maintenance plans and it won't gracefully shutdown. I'm assuming there is some system patrol writing to this iscsi volume when the condition occurs, because the windows event viewer is plague with bad sector warnings.
I've tried round-robin and failover, but the problem still occurs. Is this native to ISCSI in 2008? Is there a way to make it content with being removable? Can I make it pause or increase a timeout value to 500 seconds?