Ok Gurus,
Here is an interesting situation
I have a midsize database 55 gigs
I need to add a filegroup that is located on a NAS
I have mapped the network drive on the server
It is called the Z drive
I am trying to add a filegroup that will store a table of about 25 gigs
that will be extracted from the main table
this extraction will be completed throught a select into query
the drive is there and works but I get the following error when I try to
create the filegroup on SSMS:

Directory lookup for the file "z:\xxxxxx\xxxx_dat.ndf" failed with the
operating system error3(the system cannot find the path specified.).
One or more files listed in the statement could not be found or could
not be initialized. (microsoft sql server error: 5133)
What to do.... is this a network admin/fiewall problem?

Help


Wisord

*** Sent via Developersdex http://www.developersdex.com ***

Bill_Orova (nospam (AT) devdex (DOT) com) writes:
If this is a mapped drive, SQL Server will not see it, as mapping is
done on user level, not on server level. You would have to refer to
it with a UNC path. Then again, I'm not sure it is a good idea to
add a filegroup on a remote disk. Or if it's possible.

I believe that NAS is not really the same thing as a disk on another
computer, but you need to mount it as it was a local disk. Not that I
know how to that.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

NAS is not supported except for specific conditions. But never is a mapped
drive recommended even if you get it to work.

http://support.microsoft.com/kb/304261


--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Bill_Orova" <nospam (AT) devdex (DOT) com> wrote