How to Run DBCC CHECKDB for In-Memory OLTP (Hekaton) Tables
'tl;dr – run a copy-only full backup of the Hekaton filegroup to nul. If the backup fails, you have corruption, and you need to immediately make plans to either export all your data, or do a restore from your last good full backup, plus all your transaction log backups since.
Yeah, that one’s gonna need a little more explanation, I can tell. Here’s the background.
DBCC CHECKDB SKIPS IN-MEMORY OLTP TABLES.'...
https://www.brentozar.com/archive/2016/04/run-dbcc-checkdb-memory-oltp-hekaton-tables/#comments
Trackbacks
Keine Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt