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

Possible to undo a restore operation?

I just restored a db from its full backup and then applied its diff backup
and a log backup. Now I need to know how the db looked like before the log
backup was applied. Is it possible to undo the restore from the log backup?
Thanks,
BingNope. You will have to redo the restore and stop one step earlier.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"bing" <bing@.discussions.microsoft.com> wrote in message
news:F9861F7C-1D50-40C7-8B83-3ECCDC838AD8@.microsoft.com...
> I just restored a db from its full backup and then applied its diff backup
> and a log backup. Now I need to know how the db looked like before the
log
> backup was applied. Is it possible to undo the restore from the log
backup?
> Thanks,
> Bing

Possible to undo a restore operation?

I just restored a db from its full backup and then applied its diff backup
and a log backup. Now I need to know how the db looked like before the log
backup was applied. Is it possible to undo the restore from the log backup?
Thanks,
Bing
Nope. You will have to redo the restore and stop one step earlier.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"bing" <bing@.discussions.microsoft.com> wrote in message
news:F9861F7C-1D50-40C7-8B83-3ECCDC838AD8@.microsoft.com...
> I just restored a db from its full backup and then applied its diff backup
> and a log backup. Now I need to know how the db looked like before the
log
> backup was applied. Is it possible to undo the restore from the log
backup?
> Thanks,
> Bing