Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2001
    Posts
    24

    Unanswered: SQL SERVER 7.0 crash

    I had a crash of my SQl server 7.0 and when I restarted I couldn't enter it anymore. I had to unistall and reinstall it. I just have the mdf and ldf-files left. But now when I look in my fresh installation it doesn't add those database-files to the server. How can I do that. Please help me out as fast as possible. Thx!!!

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    So you still have all of you original database files (.mdf, .ldf). Use sp_attach_db stored procedure to 'relink' them to your new server installation. Once you've done that you'll have to recreate your login accounts again.

  3. #3
    Join Date
    Dec 2001
    Posts
    24
    Thx again!

  4. #4
    Join Date
    Aug 2002
    Posts
    1

    SQL 6.5 crash

    have same problem with SQL 6.5, can I use the same mathod and also will I have to recreate login accounts manually?

Posting Permissions

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