SQL Server and Net Apps

[Raziq Shekha]

I have SQL Server 2000 with databases on the NetApps filer CIFS share.
For example, the datafiles are located at \\network share\server
share\microsoftsqlserver\mssql\data\...

Whenever there is a filer failover, some of the databases go in suspect
mode. Is there a setting on SQL Server like a time out setting from the
net apps that can be modified so that the databases will wait for a
while before going into the suspect mode?

Raziq.
*** Sent via Developersdex http://www.developersdex.com ***

[Erland Sommarskog]

Raziq Shekha (ra**********@anadarko.com) writes:

I have SQL Server 2000 with databases on the NetApps filer CIFS share.
For example, the datafiles are located at \\network share\server
share\microsoftsqlserver\mssql\data\...

Whenever there is a filer failover, some of the databases go in suspect
mode. Is there a setting on SQL Server like a time out setting from the
net apps that can be modified so that the databases will wait for a
while before going into the suspect mode?

Overall having databases on network shares is a risky business. It may
be OK for development databases you easily can recreate, but it's
definitely not a good idea for databases you want to keep. Production
databases should be on local disk, or disks in a SAN.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx