problems with diff backup

hello.
my server sql2000 has this backup schema: monday-full and other days
diff backup.
But 2weeks back diff backups become too large -cca 1.3 GB. previous
size of diff backups was about 300mb. every diff backup in week backup
schema is incerasing from 1.3GB to 1,4GB. largest table in database is
about 500MB large. so I can't identify why about 1.3 GB is backuped
every day. Can anybody help me ?
How Diff backup stores changes ? by tables or by rows ? Thank for
answer.
thansk .Perhaps your indexes are fragmented. Try running DBCC INDEXDEFRAG or DBCC
DBREINDEX. Then see if the problem persists.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"oto pakozdy" <pakozdy@.pobox.sk> wrote in message
news:fa2dfe40.0409210421.7ea75192@.posting.google.com...
hello.
my server sql2000 has this backup schema: monday-full and other days
diff backup.
But 2weeks back diff backups become too large -cca 1.3 GB. previous
size of diff backups was about 300mb. every diff backup in week backup
schema is incerasing from 1.3GB to 1,4GB. largest table in database is
about 500MB large. so I can't identify why about 1.3 GB is backuped
every day. Can anybody help me ?
How Diff backup stores changes ? by tables or by rows ? Thank for
answer.
thansk .