Asked by
shruti
in
Computers & Accessories
at
9:03 PM on July 03, 2008
alok's Answer
If the cache controller never fails to write to disk what has been entrusted to it (even if the keyboard sticks, the operating system crashes, or the hard disk crashes), there will be no problem. On the other hand, if the disk controller delays the writing of some SQL Server log data and chooses to physically apply other log data (because of the "elevator" sorting) and fails to write the rest of it for some reason, SQL Server has no way of knowing that some of the log is missing. A warm start or even rolling forward from a snapshot backup might not restore the database correctly. In the worst case, there would be no failure during recovery and data corruption would be discovered much later.
Answered at
10:59 PM on July 03, 2008
Read all answers