Thanks Sergey

I had to use one of my MSDN issue to get this one...

This behavior is expected. Trace flag 1807 bypasses the check and allows you to configure SQL Server with network-based database files. SQL Server, and most other enterprise database systems, employ a transaction log and associated recovery logic to ensure transactional database consistency in the event of a system failure or an unmanaged shut down. These recovery protocols rely on the ability to write directly to the disk media so that when an operating system input/output (I/O) write request returns to the database manager, the recovery system is guaranteed that the write is actually complete or that the completion of the write can be guaranteed. Any failure by any software or hardware component to honor this protocol can result in a partial or total data loss or corruption in the event of a system failure. For more details about these aspects of logging and recovery protocols in SQL Server, refer to the following article in the Microsoft

Microsoft Knowledge Base Article - 304261


So I've put -T1807 in the SQL server startup parameter.



>>I wish to install our SQL server on machine linked on the LAN but I want the Data files (Databases) to reside on the SAN (Storage Area Network).
>>
>>Can it be done and how?
>
>Luc,
>
>Maybe this could help
>
>- http://www.sql-server-performance.com/ew_san.asp
>- http://activeanswers.compaq.com/ActiveAnswers/Render/1,1027,5175-6-100-225-1,00.htm
>- http://www.dell.com/us/en/esg/topics/products_sql_papers_pedge_software_microsoft_sql_papers.htm