issue with reattach database - SQL 2000 Enterprise Manager
Posted on 2007-09-29
We had a log file completely full, it was too big to use shrink command.
What I did before was detach the database, delete the log file and reattach the database and a new log file is recreated.
on this occasion i am getting the error, when i was prompted to create a new log file i got the error message
Error 1813: Could not open database 'MyDatabase' Create database is aborted.
Device activation error. The physical file name L\SQL Logs\\mydatabase_log.ldf may be incorrect.
i am using sql 2000