January 21, 2014 at 4:03 am
Hello and let's take an example:
MyDB database consists of files D:\MyDB.mdf and E:\MyDB.ldf. D: and E: - two completely independent HDD. Right now MyDB is in normal operating condition(on-line). Suddenly, the E: is completely disconnected (power is off for this drive), though D: continues to operate normally.
My question is: what will be the reaction of SQL Server on an event? I suppose, MyDB database must be immediately transferred to the state off-line, right?
January 21, 2014 at 5:21 am
I think it's about a minute before SQL declares an IO failure for the log. It's not instant.
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
January 21, 2014 at 9:14 am
OK, but one minute later(after crush of E:) MyDB WILL BE off-line, right?
January 21, 2014 at 9:43 am
The database would be marked suspect, and no users would be able to access it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply