March 20, 2009 at 10:49 am
Currently i have a job that does a differential backup of all the Databases every 4 hours. I now found that one Database however, the backup job is doing a FULL backup of that 1 Database. Any reasons why it is doing that?
March 20, 2009 at 3:08 pm
Can you locate the script that's generating the backups? You cannot do a differential via a maintenance plan so there has to be a script somewhere. One of the backup scripts will not have "WITH DIFFERENTIAL" in it. That one will default to FULL.
-- You can't be late until you show up.
March 20, 2009 at 3:19 pm
Are you sure it's actually a full backup? Maybe it’s just a differential backup of a database that has had so many pages changed that it's the same size as a full backup.
Run this command against your backup file, and it will tell you the backup type:
restore HeaderOnly from disk = 'Drive:path\backup_filename.bak'
If column BackupType is 1, it's a full backup; if it is 5, it's a differential backup.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply