|
Posted by grzegorz.gazda on 01/23/08 10:32
I had to detach the database to delete the transaction log as it took
the hole disk space.
No I am trying to attach database, however I am not able to do so.
The engine is asking me whether I want to continue and create new log
file. I agree to it, however then I am receiving an error:
Error 1813: Could not open new database 'db_name'. CREATE DATABASE
aborted. Device activation error. The physical file name 'E:\SQL
Databases\MSSQL\Data\db_name.ldf' may be incorrect.
Then after I have message than attaching database failed.
In event viewer I have:
17204 :
FCB::Open failed: Could not open device E:\SQL Databases\MSSQL\Data
\db_name.MDF for virtual device number (VDN) 0.
In the error log I have:
2008-01-23 10:28:59.00 spid52 Starting up database 'db_name'.
Do you have any ideas where the problem is?
I have never had this problem before, only now. And I didn't have this
problem with other databases for which I have deleted the log file.
Navigation:
[Reply to this message]
|