I'm having a conversation with Tony Rogerson (see his great blog at: http://sqlblogcasts.com/blogs/tonyrogerson/ ) about whether or not BACKUP will grab paged from cache (Buffer Pool, BP) or always read them from disk. It seems natural to grab the pages
Read More...