October 7, 2009 at 7:51 am
Hi all,
I am unable to create a new database.
When I try to execute, create database test;
The following errors are encountered..
Directory lookup for the file "F:\SQLData\test.mdf" failed with the operating system error 2(The system cannot find the file specified.).
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
The path, i.e. F:\SQLData\test.mdf is not the original. I changed it to the F:\ directory manually using the properties( I changed the default locations for Data and Log in Properties-> Database Settings).
Could this be the reason?
Regards,
Abhi
October 7, 2009 at 7:58 am
If the folder you are trying to use is the root folder where SQL Server was installed, have a quick look in Explorer... you may find it's marked as read only.
October 7, 2009 at 10:02 am
Does the directory F:\SQLData exist?
Does the SQL Service account have full rights to it?
Is this a clustered SQL Server?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2009 at 11:27 am
Hi guys,
Thank you all for the help.
Although I created that F:\ path long time back, it wasn't created yet. I replaced that path with the original one where all the database and log files are stored.
It is working good now. Was able to create the database and further tables as well.
Regards,
Abhi
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply