Data file on NAS

[gdroberts]

My company recently acquired a NetApp 870 Filer. We want to take advantage of the performance and reliabilty benefits of the NAS, but have now been able to find documentation on how to configure MS SQL2000 to store the data file. I can map a drive and store the file there, but that requires a login to create the connection. Obviously that is a security issue, leaving the sql server logged in with a mapped drive. Not to mention performance issues.

Does anyone know how to configure SQL2000 to use a UNC name to access files on a remote storage device?

Thanks,
greg

 

[sawdustex]

You will need to turn trace flag 1807 on. Use 'DBCC traceon (1807)'. This allows you to create or attach to your database using the 'UNC' naming convention. After you have created or attached your database, you can turn the flag off.

 

[gdroberts]

Thank you. We had turned on 1807, but were having trouble getting SQL to accept the unc name. That issue ended up being a DUI (Dumb User Issue). We were trying to browse thru UNC's instead of just typing the path. Oops.

One quirk we did notice is that the data files must be located at the root of the network share. SQL will not allow us to store the datafiles in a subdirectory on the share. The upside, we dedicated the share to the database files, so directory structure is not an issue.

Once again, thanks for the help.
Greg