Create database on NAS  
Author Message
ITeachComputer





PostPosted: Mon Aug 20 12:11:33 CDT 2007 Top

SQL Server >> Create database on NAS

I am using SQL 2005 std edtition. Everyone time I create a new database with
files being located to say \\nas\db2. I get 5110 error.(5110 (File
'file_name' Is On A Network Device Not Supported For Database Files).

I read about traceon and other MS KBs but no luck. Anyone ?

thanks

SQL Server112  
 
 
Aaron





PostPosted: Mon Aug 20 12:11:33 CDT 2007 Top

SQL Server >> Create database on NAS (a) I strongly recommend NOT using a NAS for SQL Server... this is not
exactly a robust environment to be running a high performance database
application.

(b) if you really want to go through with it, then you should be mapping a
driver letter for the SQL Server service account user (and any other user
that will need to access it). Ideally, SQL Server uses a local drive (even
if we are talking SAN / direct attached storage), but barring that, it at
least needs to *look* like a local drive.

A





>I am using SQL 2005 std edtition. Everyone time I create a new database
>with files being located to say \\nas\db2. I get 5110 error.(5110 (File
>'file_name' Is On A Network Device Not Supported For Database Files).
>
> I read about traceon and other MS KBs but no luck. Anyone ?
>
> thanks
>
>
>


 
 
Tibor





PostPosted: Mon Aug 20 13:17:24 CDT 2007 Top

SQL Server >> Create database on NAS And here's a KB on the topic:
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi




> (a) I strongly recommend NOT using a NAS for SQL Server... this is not exactly a robust
> environment to be running a high performance database application.
>
> (b) if you really want to go through with it, then you should be mapping a driver letter for the
> SQL Server service account user (and any other user that will need to access it). Ideally, SQL
> Server uses a local drive (even if we are talking SAN / direct attached storage), but barring
> that, it at least needs to *look* like a local drive.
>
> A
>
>
>

>>I am using SQL 2005 std edtition. Everyone time I create a new database with files being located
>>to say \\nas\db2. I get 5110 error.(5110 (File 'file_name' Is On A Network Device Not Supported
>>For Database Files).
>>
>> I read about traceon and other MS KBs but no luck. Anyone ?
>>
>> thanks
>>
>>
>>
>
>