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/ArticleID/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.
>

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.
>

Position opening : Web Database Programmer (Part-time temp)

I am a small business entrepreneur, and interested in
developing my own web site.
I am currently looking for a Database Programmer, who
has the skill set of MySQL , PHP running on a Linux AS
Platform.

Time is essence for this project. The front-end has
been built properly even though has not been launched
yet, we need the back- end to be done with in 3 weeks.

If you are interested in helping us to build the
back-end

Pls email to me at hhconsultinginc@.yahoo.com with your working experience or Resume.

Let me know if you have any question.

LarryWhere in Jersey?

And to build the front end then build then backened is ah...backwards...

What is the app meant to do?

Did you build an ER logical model?

Any Business flow models?

Data Models?

who is and how big is the User community?