SQL Server and Net Apps

**Erland Sommarskog** · Jun 7 '07, 09:45 PM

Re: SQL Server and Net Apps

Raziq Shekha (raziq_shekha@a nadarko.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\microsoft sqlserver\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, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

SQL Server and Net Apps

SQL Server and Net Apps

Comment