predetermine size of differential

is it possible to interrogate the differential page map prior to making
a backup? I'm interested in logic that will determine if the diff is
approaching the size of the entire database (in order to just do a full
and cut down on subsequent diff's..)
Thanks in advance.
You can try with the undocumented DBCC PAGE command - see
http://www.winnetmag.com/Article/Art...097/8097.html.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
<SNVPCUXCTYJD@.spammotel.com> wrote in message
news:1105288921.999780.38360@.c13g2000cwb.googlegro ups.com...
> is it possible to interrogate the differential page map prior to making
> a backup? I'm interested in logic that will determine if the diff is
> approaching the size of the entire database (in order to just do a full
> and cut down on subsequent diff's..)
>
> Thanks in advance.
>

predetermine size of differential

is it possible to interrogate the differential page map prior to making
a backup? I'm interested in logic that will determine if the diff is
approaching the size of the entire database (in order to just do a full
and cut down on subsequent diff's..)
Thanks in advance.You can try with the undocumented DBCC PAGE command - see
http://www.winnetmag.com/Article/Ar...8097/8097.html.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
<SNVPCUXCTYJD@.spammotel.com> wrote in message
news:1105288921.999780.38360@.c13g2000cwb.googlegroups.com...
> is it possible to interrogate the differential page map prior to making
> a backup? I'm interested in logic that will determine if the diff is
> approaching the size of the entire database (in order to just do a full
> and cut down on subsequent diff's..)
>
> Thanks in advance.
>