Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: Unable to attach a database

    ... Because one of the multiple .ldf files was overwritten by accident.

    I have tried to restore the database, without success. I guess it is because the database is detached?

    sp_attache_single_file_db did not work, nor did sp_attach_db.


    Is it possible to attach a database with multiple logfiles even though only one of them exist?

    Thanks

  2. #2
    Join Date
    Nov 2003
    Posts
    2
    Problem "solved", we had to go around the real problem and make a complete restore of the backups. Not always a good solution, but it works if you make frequent backups

Posting Permissions

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