Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2003
    Posts
    3

    Unanswered: Recovering MDF file!! Need Assistance!!!!!

    Somehow, our MS SQL 2000 Server database mdf file size is 0,
    The database is in suspected state. and the backup file related to that database shown 0 size.
    Its totaly weird as there are many databases in server group but just one database's mdf file and backup file size is 0.

    Any idea how this can possibly happen and is there any way to recover it from this state

    Thank you very much

  2. #2
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    sp_resetstatus

    Try running sp_resetstatus 'DBNAME' .
    For a Suspect database the query "Select Status from master..Sysdatabases' would return 256.
    The above sp should set it back to 0.

    Also restoring the database file will turn off the suspect mode.

  3. #3
    Join Date
    Feb 2003
    Posts
    3

    no mdf and no backup

    reseting status did not help cause mdf files' physical size on the HD is zero bytes. the backup files size is as same as its

    IS there a way to see a log file in sql to see what has happened?

  4. #4
    Join Date
    Jan 2003
    Location
    Surrey, UK
    Posts
    23
    The only tool I have heard of that does this is Lumigent Log Explorer. It is fairly expensive though...

    http://www.lumigent.com/products/le_sql/le_sql.htm
    Andy


  5. #5
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    My guess is that there is something wrong with your backup procedure (has it ever been tested) and that the zero length file has been restored.

Posting Permissions

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