HennyBöhnisch Posted January 29, 2018 Share Posted January 29, 2018 All of my databases on MS SQL Server 2012 work great. One of them has viewed message only today - Database consistency errors reported by DBCC CHECKB. I've no idea what to apply and how to work next. Link to comment Share on other sites More sharing options...
0 Seahorsepip Veteran Posted January 29, 2018 Veteran Share Posted January 29, 2018 https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql Quote DBCC CHECKDB is supported on databases that contain memory-optimized tables but validation only occurs on disk-based tables. However, as part of database backup and recovery, a CHECKSUM validation is done for files in memory-optimized filegroups. Since DBCC repair options are not available for memory-optimized tables, you must back up your databases regularly and test the backups. If data integrity issues occur in a memory-optimized table, you must restore from the last known good backup. If your database has memory-optimized tables then you're out of luck and the only option is to restore from a backup. Otherwise you can repair the database using the REPAIR command. Link to comment Share on other sites More sharing options...
Question
HennyBöhnisch
All of my databases on MS SQL Server 2012 work great. One of them has viewed message only today - Database consistency errors reported by DBCC CHECKB. I've no idea what to apply and how to work next.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts