Backups & the Buffer Pool

Published On: 2013-07-03By:

    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, SQL Server simply takes the data from the data files and writes it to the backup file.  During the backup process the dirty pages are written to the disk by the checkpoint process being triggered by the backup database process.

    Because the backup process simply reads the data files and writes them to the backup location there’s no need to cache the data in the buffer pool as this data isn’t being queried by a normal SQL query.

    Denny


    Contact the Author | Contact DCAC

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner    Microsoft MVP    Microsoft Certified Master    VMWare Partner    VMWare vExpert
   Best Full-Service Cloud Technology Consulting Company    Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers
Share via
Copy link