How to fix the error in my database?

• keithy_sunny

  Mr or Mrs. 500

  Points: 566

  More actions

  November 2, 2015 at 12:14 am

  #322224

  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.

• Ant-Green

  SSC Guru

  Points: 112965

  More actions

  November 2, 2015 at 1:55 am

  #1836992

  Whats the full output of

  DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLERESULTS