Backup and Recovery of Memory-Optimized Databases
Memory-optimized tables are backed up as part of regular database backups. A full backup of a database with one or more memory-optimized tables consists of the allocated storage for disk-based tables (if any), the active transaction log, and the data and delta file pairs (CPFs) for memory-optimized tables. It’s important to keep in mind that the storage used by the CPFs for memory-optimized tables can be much larger than its size in memory, and it affects the size of the database backup.
For databases where the activity on the memory-optimized tables is primarily inserts, most of the memory-optimized tables data files will be in the Active state, fully loaded, and with very few deleted rows. ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
