Hi All,
Does a diff backup (on either 2000 or 2005) backup only the changed pages or extents?
There are various solid sources that provide conflicting info.
Thanks
Rob
Differential backup creates copy of all the pages in a database after the last backup operation.
as for my understanding , the data is stored in pages and each page size is 8 KB and an extent is a collection of contiguous 8 pages. so some pages in the extents might be left blank or unused.so my understanding is it takes pages in differential backup.
please let me knw if you find the correct solution
Thanks
Madhu
|||Rob, I agree with Madhu that differential backup backup the changed pages.
Vincent
Actually we always backup at the granularity of an extent (8 pages).
But you are partially correct: it is the change to an individual page that marks an extent for backup.
Cheers
|||Thank you for correcting us, Steve.Vincent
