Posted by Erland Sommarskog on 06/07/07 21:43

Raziq Shekha (raziq_shekha@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, esquel@sommarskog.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

• Next in forum: Re: float storage and usage
• Prev in forum: Re: hierarchical selection within a select statment
• Thread view: Re: SQL Server and Net Apps

[Reply to this message]