Recover a Database with no Log

  • How does one recover a database whose transaction log size inexplicably goes to 0. No backups are available.

  • Try detaching the database then try sp_attach_single_file_db after renameing the log file. However a log size of 0 may not be a true issue, are you getting errors or the DB marked suspect?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Yes the Db is marked suspect and offline.

    Attach in enterprise manager fails.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply