[Cialug] [Way OT] that evil company's database won't reattach

[Jon Clemons]

http://www.sqlservercentral.com/columnists/awarren/attachanddetachagain.asp




----- Original Message ----- 
From: "Barry Von Ahsen" <barry at vonahsen.com>
To: "Central Iowa Linux Group" <cialug at cialug.org>
Sent: Tuesday, June 21, 2005 1:05 PM
Subject: [Cialug] [Way OT] that evil company's database won't reattach


> this is where the geeks are, so I ask here:
> 
> I have an MSSQL database that I detached and deleted the log.ldf.  Now 
> when I try to reattach, it won't do it.
> 
> Enterprise manager, and query analyzer using sp_attach_single_file_db 
> and sp_attach_db both fail with error 1813:
> Device activation error. The physical file name 'c:\path\to\file.ldf' 
> may be incorrect.
> 
> anyone come across this before and fix it?  everything says that I 
> should be able to reattach and have the log file recreated
> 
> -barry
> 
> 
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>