Can''t attach db - Transaction log full

  • Thanks for your efforts, Yelena, but...

    >> 1. Use sp_attach_single_file_db (see syntax in Books Online in the SQL Server Star Menu) because it uses only the database file and creates a new transaction log <<

    Yeah, that's what I read in BOL myself, so I tried it, but it didn't work for me. I forget the exact error it raised now, but all the errors have realated to the transaction log. 

    I've tried everything everyone has suggested, and disk space is not an issue. Sometimes somethings simply remain mysteries, I guess.

    Anyhoo...I have it all working now from a backup. I do appreciate all the advice you have given me.

    You folks are the best around.

    Lee...

Viewing post 16 (of 15 total)

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