Re: predetermine size of differential

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 01/10/05 

Date: Mon, 10 Jan 2005 08:34:14 +0100

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

Relevant Pages

  • Re: best way to scrub data
    ... Dejan Sarka, SQL Server MVP ... This message does not imply endorsement from Solid Quality Learning, ... > sensitive data like user info,credit card info,etc.. ...
    (microsoft.public.sqlserver.security)
  • Re: clearing concept
    ... and Extents" chapter. ... >> Dejan Sarka, SQL Server MVP ... >> Solid Quality Learning ...
    (microsoft.public.sqlserver.clients)
  • Re: Change sql agent login user
    ... Dejan Sarka, SQL Server MVP ... Solid Quality Learning ... "shivi" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: how to order by string data type that is actually numeric?
    ... Dejan Sarka, SQL Server MVP ... Solid Quality Learning ... "Bobby" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: Why i can not see other drive?
    ... > command but still the same, ... Check whether the account SQL Server uses has ... Dejan Sarka, SQL Server MVP ... Solid Quality Learning ...
    (microsoft.public.sqlserver.server)
Loading