Differential Backups: Pages or Extents?

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

Different Data Sources

I am a RS newbe, and I have common reports but different data sources. Is
there a way to modify the data source for an instance of a report without
changing the values in the ReportServer database?
--
BobRS 2005 supports expression-based connection strings with private data
sources only. Look at the ExpressionBasedConnection report
here(http://prologika.com/CS/blogs/blog/archive/2005/12/08/714.aspx)
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Bob Joyce" <BobJoyce@.discussions.microsoft.com> wrote in message
news:E813E946-5635-491A-973C-F4ADB4A63726@.microsoft.com...
>I am a RS newbe, and I have common reports but different data sources. Is
> there a way to modify the data source for an instance of a report without
> changing the values in the ReportServer database?
> --
> Bob