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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 problem creating database

Author  Topic 

nukitsamees
Starting Member

1 Post

Posted - 2010-06-14 : 10:17:20
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "D:\MSSQL\DATA\baas1.mdf" failed with the operating system error 3(failed to retrieve text for this error. Reason: 15105).
Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

CREATE DATABASE baas1 ON PRIMARY
( NAME = N'baas1',
FILENAME = N'D:\MSSQL\DATA\baas1.mdf' ,
SIZE = 3072KB ,
FILEGROWTH = 1024KB )
LOG ON
( NAME = N'baas1_log',
FILENAME = N'D:\MSSQL\DATA\baas1_log.ldf',
SIZE = 1024KB,
FILEGROWTH = 10%)
GO


all errors i get, end with (failed to retrieve text for this error. Reason: 15105)
tried to restore backup, even that didnt work

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-14 : 12:36:09
Run chkdsk to verify your disks, check the Application Log in Event Viewer.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-06-14 : 13:11:31
Does folder

D:\MSSQL\DATA

exist on D: drive ?

If so does the file D:\MSSQL\DATA\baas1.mdf already exist?
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2010-06-14 : 13:34:45
exec master..xp_cmdshell 'Dir D:\MSSQL\DATA\*.*'


And if That's not enabled...call a dba...

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -