views:

36

answers:

1

I detached a database, and when i try to re-attach it i am getting error:

CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\RoadMap.mdf'. (Microsoft SQL Server, Error: 5123)

Is there a way i can delete that database and create new one instead of re-attaching it.

A: 

I Just had to delete the database logs from the defualt location and i was able to create new database.

Thanks

WingMan20-10