April 27, 2006 at 9:01 am
I am a little confused as to what is going on with my diff backups. I run the following statement Sunday morning to do a FULL backup resulting in 21GBs backup set. VERY little processing goes on during the course of Sunday into Monday morning.
BACKUP DATABASE [database] TO DISK = N'M:\backup\database.bak' WITH INIT , NOUNLOAD , NAME = N'database backup Full', NOSKIP , STATS = 10, NOFORMAT
Monday morning I run the following command against the same db resulting in a 19GBs differential backup. How could that be? Isn't the differential backup the difference from the time the full backup ran till the running of the differential?
BACKUP DATABASE [database] TO DISK = N'M:\backup\database.bak' WITH INIT , NOUNLOAD , DIFFERENTIAL , NAME = N'database backup Diff Mon', NOSKIP , STATS = 10, NOFORMAT
April 27, 2006 at 9:39 am
Are you rebuilding indexes on Sunday? That would cause a lot of changes to extents as stuff is moved around in the data file.
Greg
Greg
April 27, 2006 at 9:44 am
Oversite on my part. That would explain a lot. So the rest of the weeks differential backups will be at least 19GBs and increase with whatever data changes were made?
April 27, 2006 at 9:57 am
Yes, if you do full backups only on Sunday morning. Maybe you could schedule your reindexing to occur before the weekly full backup?
Greg
Greg
May 1, 2006 at 9:51 am
Mike,
May be you could place your database in the simple recovery mode before reindexing. Once reindexing is done you put it back in full recovery mode and do the full backup...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply