I have some SQL Server databases running off a SAN storage from 2 seperate Windows2003 servers. Last week there was a disk controller error on the SAN(this controller is shared for all servers connected to the SAN) for a few seconds.
This affected only one server which lost access to the data files residing on the SAN. The second server continued to access the files without any problems.
Both the servers are of similiar configuration and have similiar OS. What could be the reason for the difference in behavior? Is there any setting in SQL Server 2000 which asks it to timeout after a certain time when it loses connectivity to the disks? What is the default value? Please help.