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!

ashish.kuriyal (2/13/2010)

---

What is important is your log backup must be at regular frequency as per your database size

Bru Medishetty (2/10/2010)

---

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.

GT-897544 (2/15/2010)

---

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).