Diff backup Problems

Hi,
I am taking a diff backup of a read only database over a
network link but the size of the diff backup is the same
as the normal backup.
Is there any thing that I need to take in account as the
database is sometimes put to read write and then to read
only mode so need a differential
Thanks
Anup
Hi
Eventually. enough pages would have changed in the DB that the differential
is the same as a normal backup.
e.g.
If every index in clustered, and every index gets re-built, in effect the
whole DB's pages will have changed.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ap" <anonymous@.discussions.microsoft.com> wrote in message
news:00f401c5185f$39b32a50$a601280a@.phx.gbl...
> Hi,
> I am taking a diff backup of a read only database over a
> network link but the size of the diff backup is the same
> as the normal backup.
> Is there any thing that I need to take in account as the
> database is sometimes put to read write and then to read
> only mode so need a differential
> Thanks
> Anup
|||Checked all but no such thing something has changed so
any ideas what to do ?

>--Original Message--
>Hi
>Eventually. enough pages would have changed in the DB
that the differential
>is the same as a normal backup.
>e.g.
>If every index in clustered, and every index gets re-
built, in effect the
>whole DB's pages will have changed.
>Regards
>--
>Mike Epprecht, Microsoft SQL Server MVP
>Zurich, Switzerland
>IM: mike@.epprecht.net
>MVP Program: http://www.microsoft.com/mvp
>Blog: http://www.msmvps.com/epprecht/
>"ap" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:00f401c5185f$39b32a50$a601280a@.phx.gbl...
a[vbcol=seagreen]
same[vbcol=seagreen]
the[vbcol=seagreen]
read
>
>.
>
|||Hi,
When was the last full backup taken?
I suggest that you take a latest full backup and then the differential
backup. If you still have the same question, please let us know the size of
the original full backup file vs differential backup file size.
Thanks
Yogish