Post reply

Recover a Database with no Log

  • April 26, 2002 at 1:12 am

    #57660

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

  • April 26, 2002 at 4:28 am

    #427924

    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)

  • April 26, 2002 at 12:35 pm

    #427965

    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