Search results for query: *

The entire error message is: Error 1813: Could not open new database 'West'. CREATE DATABASE is aborted. Device activation error. The physical file name 'D:\MSSQL\Data\West_log.ldf' may be incorrect. if I leave out the LDF, even though the folder D:\MSSQL\Data exists. If I just try to attach...

The MDFs have different names (listed in an earlier post). They are both indeed MDFs. One is about 200 MB, the other about 18GB.

I can't use sp_attach_single_file_db because there are two MDFs. I've also tried CREATE DATABASE ... FOR ATTACH, since that's what is produced by sp_attach_db. That doesn't work either - I get the same error.

I've created the necessary folders(empty) in the path specified, but still get the same error. The entire error message is: Error 1813: Could not open new database 'West'. CREATE DATABASE is aborted. Device activation error. The physical file name 'D:\MSSQL\Data\West_log.ldf' may be...

When I try to attach the database and select the main MDF (West.mdf) three entries appear: E:\West.mdf, E:\West_1.mdf, and E:\West_log.ldf. I've tried various combinations with the third entry (E:\,E:\test.ldf, etc) and the first dialog box says the filename specified for the log file is...

SQL Server 2000 SP4, fairly large (30GB) database. We lost power to the server and the RAID controller refused to come back up. Our backup tape is unreadable. Using a data recovery/RAID rebuilding service, I have recovered the 2 MDFs and the LDF but I get an error processing the log when I...