Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    Exclamation Unanswered: Recover database - HELP, PLEASE

    My database (MS SQL 2k) has been crushed some days ago. I've no any backup, but I need to restore information as much as possible. Trouble is... I've lost last file in filegroup (it's broken), that contents images only. (All images were in three .ndf files, 9Gb each of them).
    Please, tell me - is it possible to restore any information?

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1

    Red face Attaching a db file.

    I haven't had to do this, but in SQL 2000 you may be able to attach the file (you do still have the file, don't you?) directly to the database, or perhaps as a new database from which you can recover your data.

    Search SQL Books Online for "attaching databases", "sp_attach_db", or "sp_attach_single_file_db".

    Good luck, and back up!


Posting Permissions

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