Unanswered: Help, DB detached, then logs deleted...
We have a database that had one log file. A second one was manually added. We have a stored proc we wrote called sp_ShrinkLog. When ran, it detaches the database, deletes the log (expecting there to only be one log), then reattaches the database (which creates a new smaller log).
sp_ShrinkLog was ran against the database, but it of course only deleted the log that resided in the same directory as the .MDF. The attach_db failed because of the log situation. The second log (the one that wasn't deleted by sp_ShrinkLog) was deleted manually, then we tried to re-attach the database. It won't let us attach it now.
How can we get this attached? This database is about 35G, so recreating the data would obviously take a while.