• 0

i'm working as database admin


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 post
Share on other sites

1 answer to this question

Recommended Posts

  • 0
Seahorsepip

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 post
Share on other sites
This topic is now closed to further replies.
  • Recently Browsing   0 members

    No registered users viewing this page.