hi team, i have a issue these days ,we have a databases of 35GB in size full backup, when we create a differential backup,its size grows upto 23 GB, i have verified the backup set using restore verifyonly from disk ='
A differential backup creates a copy of all the pages in a database modified after the last database backup. So the size really depends with the period of Last full backup and the recent Differential backup. In a nutshell it is Ex: you had a full backup on Jan 1st around 10 GB imagine you had a differential backup on Jan 15 then the size of your differential backup is from Jan 1st to Jan 15 say it comes 2 GB For Feb 1st again u had a diff backup then the size of differential backup will be from 1st of jan to 1st of Feb(Remember the differential backups are not Incremental backups) i.e From your last full backup. In a nutshell the size of a differential backup depends on the amount of data that has changed since the base. Generally, the older a base is, the larger a new differential backup will be. A specific differential backup captures the state of changed extents at that time that backup is created. I suggest you to go throught [Differential Backup MSDN] article :
How old is your last FULL backup? If you have a really old base FULL you could experience this sort of situation. You don't just do differentials forever after an initial backup. You need new FULL backups to begin a new round of differentials. For instance some places do a FULL on Saturdays and daily differentials on all the other days. When I first read the question my reaction was "victim of their success", by which I mean you must have a busy dB. Then after having some coffee I realized you were talking 2/3 of the dB as a differential. That's large, (not unheard of though) but 22 GB is a lot of activity.