Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2001
    Posts
    5

    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.

    Any help would be greatly appreciated.

    Thanks

  2. #2
    Join Date
    Nov 2001
    Posts
    5
    This appears to be our situation:

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;q271223

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •