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.
| Author |
Topic |
|
dio
Starting Member
3 Posts |
 Posted - 2004-07-31 : 14:06:36
|
| Hi,I accidentaly deleted a database, then recovered the MDF file and am trying to attach the database. However, having prompted me to create a new log file, the process aborts after the following message:Error 1813: Could not open new database 'db'. CREATE DATABASE is aborted. Device activation error. The physical name '<path>\db_log.ldf' may be incorrect.I have also tried using sp_attach_db and sp_attach_single_file_db, attaching to a different server - result was the same. Is there any way to restore the database?Thanks,Denys |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-31 : 17:26:54
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37161may helpKristen |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-01 : 14:57:17
|
| You didn't have a backup????????MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Restoring MDF