May 13, 2011 at 10:00 am
My random thought for a Friday and I am sure if I had one of my Internals books by my side it would be in there, but what is the deal with the differential backup?
A differential backs up any extent that has changed since the last full. Well, if there was only one change in a given extent, the entire extent is backed up. Why not just grab the page that changed? Yeah, extents are a basic building block of SQL Server..... just seems like there might be a better way to do that.
May 13, 2011 at 12:29 pm
You can not back up a page so you are going to have to stick with the current backup strategy.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 12:46 pm
Right. I understand that. Just wondering why MS architected it that way.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply