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 https://www.neowin.net/forum/topic/1354628-im-working-as-database-admin/ 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 https://www.neowin.net/forum/topic/1354628-im-working-as-database-admin/#findComment-598176532 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
https://www.neowin.net/forum/topic/1354628-im-working-as-database-admin/Share on other sites
1 answer to this question
Recommended Posts