Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2013
    Posts
    19

    Unanswered: How to fix the error in my database?

    Hi,

    I have a database. I can attach it to SQL Server with Management Studio and perform query on the tables. But when I run the following commands:

    ALTER DATABASE UFDATA_008_2013 SET SINGLE_USER;
    DBCC CHECKDB('UFDATA_008_2013', REPAIR_REBUILD);

    I will get the following errors:

    Msg 8921,Level 16,State 1,Line # 3
    Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
    Msg 605,Level 21,State 3,Line # 3
    Attempt to fetch logical page (1:209549) in database 6 failed. It belongs to allocation unit 72057600521535488 not to 281474979397632.

    I then try with the following commands by switch to emergency mode and invoke checkdb with REPAIR_ALLOW_DATA_LOSS, but still get the above error messages:

    ALTER DATABASE UFDATA_008_2013 SET EMERGENCY;
    ALTER DATABASE UFDATA_008_2013 SET SINGLE_USER;
    DBCC CHECKDB('UFDATA_008_2013', REPAIR_ALLOW_DATA_LOSS);
    ALTER DATABASE UFDATA_008_2013 SET MULTI_USER;

    How to fix the problem? I do NOT have a backup of the database.

    Thank you very much.

  2. #2
    Join Date
    Jan 2016
    Posts
    24
    Provided Answers: 1
    If you don't have a clean backup, then the only option is to export what data you can and script all objects and recreate the database with what you managed to extract or you can use a third party commercial tool like free SQL mdf recovery tool

  3. #3
    Join Date
    Jun 2011
    Posts
    31
    Provided Answers: 1

    Post

    Quote Originally Posted by johnwalker10 View Post
    If you don't have a clean backup, then the only option is to export what data you can and script all objects and recreate the database with what you managed to extract or you can use a third party commercial tool like free SQL mdf recovery tool
    This is too old post to answer. Try to give answer the same day.

  4. #4
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    Quote Originally Posted by addisionphilip View Post
    This is too old post to answer. Try to give answer the same day.
    Just out of interest, how is someone who joined in January 2016 supposed to have answered a query in April 2013?
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Tags for this Thread

Posting Permissions

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