February 15, 2010 at 1:48 pm
Bru Medishetty (2/10/2010)
GT-897544 (2/10/2010)
I agree with Gail, but diff backup takes almost same time and space as full backup again it depends. Personally i would prefer full back every night and log backup once every hour, with SQL 2008 compression you will save lot of space on full backups.EnjoY!
I don't agree with you on the time taken for a diff backup. The time taken perform a Diff backup will be far lower than the time taken perform a Full backup. Since the differential backup backups only the changes since the last full backup it would be only backing up those modifications.
If there is a DB which is 450 GB (grown over a period of 2 years), and there are changes worth 1 GB for each day, the daily Diff backup will be of the size of that much (1 GB) on day one and tends to grow, since diff backups are cumulative. At any point it would be still be lower than the full backup.
And regarding, log backups every one hour, that needs to decided by the amount of data modifications since the transaction log file will keep increasing without log backups.
I Knew that, but diff backup takes almost same time and space as full backup again it depends (I was refereing if it was almost same size).
February 15, 2010 at 2:19 pm
GT-897544 (2/15/2010)
Bru Medishetty (2/10/2010)
GT-897544 (2/10/2010)
I agree with Gail, but diff backup takes almost same time and space as full backup again it depends. Personally i would prefer full back every night and log backup once every hour, with SQL 2008 compression you will save lot of space on full backups.EnjoY!
I don't agree with you on the time taken for a diff backup. The time taken perform a Diff backup will be far lower than the time taken perform a Full backup. Since the differential backup backups only the changes since the last full backup it would be only backing up those modifications.
If there is a DB which is 450 GB (grown over a period of 2 years), and there are changes worth 1 GB for each day, the daily Diff backup will be of the size of that much (1 GB) on day one and tends to grow, since diff backups are cumulative. At any point it would be still be lower than the full backup.
And regarding, log backups every one hour, that needs to decided by the amount of data modifications since the transaction log file will keep increasing without log backups.
I Knew that, but diff backup takes almost same time and space as full backup again it depends (I was refereing if it was almost same size).
I had never seen a differential backup (worth a 7 days of data) being equal in size with the full backup size.. Can you quote under what conditions would that be equal (with respect to the scenario I mentioned or with your own example)
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 15, 2010 at 11:30 pm
If your differential backup is almost the same size and takes almost the same amount of time, then almost your entire database is getting updated in between. If you are experiencing htis, then you have soemthing wrong with your system or you're not taking the backups frequently enough.
What is the backup schedule?
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply