• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

size of DB for diff backups

at what size of the database is differential backups more recommended?

(like >100 GB etc)- because if the database is smaller, the full backup will be fast enough.
0
anushahanna
Asked:
anushahanna
4 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
I personally won't prefer Differential backups and would go for Full Backup with Transactional Log backup.

Say if you have Diff backup scheduled to run every 2 hrs, then

First Diff Backup = X size
Second Diff Backup = First Backup + Y Size
and so on..

Thereby occupying more of your disk space and your disk utilization is not good.
Instead having a full backup with purging older full backups or full backups with transactional log backup would be a good idea..
0
 
slam69Commented:
Agree with teh above and if you have a Dr backup and are doing backups look to log ship your tran logs to cut your restoration time down.... whilst i know a lot of people do like them ive never been able to get value out of diff backups when looking at the space implications required for storing them
0
 
rajeevnandanmishraCommented:
Hi,

While agreeing to the above comments, I would still strongly believe that taking the differential backup is not about only the size of database. The differential backup, run over the transaction log and  take only the backup of the activities performed after the last Full Backup. And that is comparatively very very small, considering any database size.  Also the time in which you should schedule your differential backup, is actually the duration for which a maximum loss is acceptable. Like if you have scheduled the diff backup for 1 hour, then you are accepting that a maximum loss of 1 hour is acceptable to the user.

0
 
rocky_lotus_newbieCommented:
It varies froom Database to Database depending on the data access patterns. FOr some databases, if most of the pages are updated between successive differential backups, then the differential back up is as big as the full backup. In this case, it is not ideal. On the other hand if the number of pages modified is small, differential backups are best bet.

The Main advantage of Differential Backups is for Data Recovery.

I normally configure differential backups for every 4 to 6 hours. Just to make sure the recoveries are faster in case of a disaster.

However, if there is space constraint, we need to go with just the Transaction Log Backups.
0
 
anushahannaAuthor Commented:
thanks for your helpful feedback.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now