Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
emundorf
Starting Member
15 Posts |
 Posted - 2007-01-30 : 18:46:15
|
| I am trying to remotely create a database through a database creation tool I created, and I keep getting the following error:The file "\\10.116.204.105\Data\WMS_TDMN_Data.MDF" is on a network path that is not supported for database files.CREATE DATABASE failed. Some file names listed could not be created. Check related errors.The path is located on a RAID 5 server. I can create a database while on the server on the E: drive. Also, my application can drop the database remotely from my laptop, but it cannot recreate it.The creation works with no problem on the C:\ drive. The server is on a different VLAN, but I have the privileges to access it. The problem appears to be related to the 3 hard drives combined together as the E: drive. I have excellent skills in SQL, but my understanding of RAID is about nothing. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-30 : 18:56:19
|
| You can't use UNC paths in the CREATE DATABASE command. It needs to be a local path. Local path meaning in the perspective of the database server.Tara Kizer |
 |
|
|
emundorf
Starting Member
15 Posts |
Posted - 2007-01-30 : 19:10:24
|
| Yeah, your right. I should have realized that. But when I try to create the database on the RAID drive with the path E:\Data, I get the error "Could not find a part of the path 'E:\Data'". I did share the folder. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-30 : 19:12:53
|
| Sharing isn't something you have to touch when creating a database. Please post the command that you used that got the error for E:\Data.Tara Kizer |
|
|
|
emundorf
Starting Member
15 Posts |
Posted - 2007-01-30 : 19:25:34
|
| if (!Directory.Exists(this.DataFilePath)) Directory.CreateDirectory(this.DataFilePath);Sorry for wasting your time. As I was reading your reply, I realized that I was searching for the existence of a drive for creating the files locally, when it should have been looking remotely. I don't have an E:\ drive on my laptop. I usually test creating the database files on the C:\ drive, so I never saw the problem before.Thanks again! |
|
|
|
|
|
|
CREATE DATABASE failed