How to setup NAS for data storage

[blakmk]

How do I get sql server to recognise a drive i've mapped on to a NAS device?

The drive appears as FAT network drive and I get the following sql server error whenever I try to create a database on this disk.

CREATE FILE encountered operating system error 3(The system cannot find the path specified.) while attempting to open or create the physical file 'G:\Data\MB_TEST2_data.mdf'.

Im using 2000 server with sql server 2000

 

[jymm]

I do not think it can be done. I seem to remember that it has to be a physical drive on the server for you to reference it through SQL - kinda goofy in my opinion, but when you take the MS class it makes more sense.

 

[tlbroadbent]

Have you read the article at...

http://support.microsoft.com/default.aspx?kbid=304261

If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[jymm]

very cool Terry - I missed that one