Backups & the Buffer Pool
As we know with Microsoft SQL Server everything is processed from disk and loaded into the buffer pool for processing by the query engine. So what happens to the buffer pool when backups are taken? The answer is that nothing happens to the buffer pool. When SQL Server is backing up data from the disk, […]
Backups & the Buffer Pool
As we know with Microsoft SQL Server everything is processed from disk and loaded into the buffer pool for processing by the query engine. So what happens to the buffer pool when backups are taken? The answer is that nothing happens to the buffer pool. When SQL Server is backing up data from the disk, […]