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 |
|
SqlZ
Yak Posting Veteran
69 Posts |
 Posted - 2001-11-15 : 21:10:19
|
| Okay, here's the situation.Detached db TempEDWDB, blew away the log file, and tried to reattach. I get the message.After I write:sp_attach_single_file_db @dbname = 'TempEDWDB', @physname = 'E:\MSSQL\Data\TempEDWDB_Data.MDF'I Get:Server: Msg 1813, Level 16, State 2, Line 1Could not open new database 'TempEDWDB'. CREATE DATABASE is aborted.Device activation error. The physical file name 'e:\MSSQL\data\TempEDWDB_Log.LDF' may be incorrect.Is there any way I can stop the Server from looking for this log file and just create a new one. I have detached, blew away log files, and attached dbs many times. I don't know why I received this. Any ideas or suggestions.Thanks in advance.========================My username represents the two things that consume most of my time.SQL, and my Z |
|
|
|
|
|
Having Problems with Attaching an .MDF