Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. Msg 8948, Level 16, State 6, Line 5
  2. Database error: Page (1:1737) is marked with the wrong type in PFS page (1:1). PFS status 0x40 expected 0x60.
  3. Msg 8948, Level 16, State 6, Line 5
  4. Database error: Page (1:1738) is marked with the wrong type in PFS page (1:1). PFS status 0x40 expected 0x60.
  5. Msg 8948, Level 16, State 6, Line 5
  6. Database error: Page (1:1739) is marked with the wrong type in PFS page (1:1). PFS status 0x40 expected 0x60.
  7. Msg 8948, Level 16, State 6, Line 5
  8. Database error: Page (1:1740) is marked with the wrong type in PFS page (1:1). PFS status 0x40 expected 0x60.
  9. Msg 8948, Level 16, State 6, Line 5
  10. Database error: Page (1:1741) is marked with the wrong type in PFS page (1:1). PFS status 0x40 expected 0x60.
  11. Msg 8948, Level 16, State 6, Line 5
  12. Database error: Page (1:1742) is marked with the wrong type in PFS page (1:1). PFS status 0x40 expected 0x60.
  13. Msg 8948, Level 16, State 6, Line 5
  14. Database error: Page (1:1743) is marked with the wrong type in PFS page (1:1). PFS status 0x40 expected 0x60.
  15. CHECKDB found 7 allocation errors and 0 consistency errors not associated with any single object.
  16. CHECKDB found 7 allocation errors and 0 consistency errors in database 'DBNAME'.
  17. repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (DBNAME).
  18.  
  19. SELECT s.name, o.name, a.index_id
  20. FROM sys.schemas AS s
  21. INNER JOIN sys.objects AS o
  22. ON s.[schema_id] = o.[schema_id]
  23. CROSS APPLY sys.dm_db_database_page_allocations
  24. (DB_ID(N'DBNAME'),o.[object_id],NULL,NULL,N'LIMITED') AS a
  25. WHERE allocated_page_page_id BETWEEN 1737 AND 1743;
  26.  
  27. DBCC TRACEON(3604,-1);
  28. DBCC PAGE(N'DBNAME', 1, 1737, 2);
  29. DBCC PAGE(N'DBNAME', 1, 1738, 2);
  30. DBCC PAGE(N'DBNAME', 1, 1739, 2);
  31. ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement