Monday, February 20, 2012

KB892923....questions.

We do weekly fulls, daily differentials, and hourly trans logs on all user
db's and on all SQL servers (~30). So I am concerned and what to understand
completely.
http://support.microsoft.com/default.aspx?scid=kb;en-us;892923
FIX: Differential database backups may not contain database changes in the
Page Free Space (PFS) pages in SQL Server 2000
snip>
In SQL Server 2000, differential backups may not contain Page Free Space
(PFS) pages if the following conditions are true: . The PFS page was
allocated between the last full backup and the differential backup.
. The PFS page allocation was part of a file growth that is larger
than 64 MB
Concerning first bullet.
1) How would the PFS page be allocated between Full and Diff if there was
not some sort of db growth ether auto or manual?
Concerning second bullet.
2) Is this implying if one of the data files grows ether auto or manual in
one leap more than 64mb?> 2) Is this implying if one of the data files grows ether auto or manual in
> one leap more than 64mb?
Sure, if your database file is 40 GB and you have autogrow set to 10%,
that's a lot more than 64 MB.

No comments:

Post a Comment