pidge45 Posted June 9, 2007 Report Share Posted June 9, 2007 Hi I am trying to create a new database using SQL Server 05 and I keep getting this error message:Msg 5133, Level 16, State 1, Line 1Directory lookup for the file "J:\Sales_Data\SalesPrimary.mdf" failed with the operating system error 3(error not found).Msg 1802, Level 16, State 1, Line 1CREATE DATABASE failed. Some file names listed could not be created. Check related errors.I have created the volumes J,K and L and I have created the folder Sales_Data in each but it appears SQL just can't see them? I used exactly the same statement on my old pc using XP Pro with no trouble so I am wondering either what I am doing wrong or if it is a Vista issue. This is the statement I am using:CREATE DATABASE SalesONPRIMARY(NAME = SalesPrimary,FILENAME = 'J:\Sales_Data\SalesPrimary.mdf',SIZE = 50MB,MAXSIZE = 200,FILEGROWTH = 20),FILEGROUP SalesFG(NAME = SalesData1,FILENAME = 'K:\Sales_Data\SalesData1.ndf',SIZE = 200MB,MAXSIZE = 800,FILEGROWTH = 100),( NAME = SalesData2,FILENAME = 'K:\Sales_Data\SalesData2.ndf',SIZE = 400MB,MAXSIZE = 1200,FILEGROWTH = 300),FILEGROUP SalesHistoryFG(NAME = SalesHistory1,FILENAME = 'K:\Sales_Data\SalesHistory1.ndf',SIZE = 100MB,MAXSIZE = 500,FILEGROWTH = 50)LOG ON(Name = Archlog1,FILENAME = 'L:\Sales_Data\SalesLog.ldf',SIZE = 300MB,MAXSIZE = 800,FILEGROWTH = 100)The folders have enough room and I have full permissions on the pc. Any help anyone can give me would be very much appreciated. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.