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

SQL : Full Backup Vs Incremental Backup

We have a third party Workflow Software. I prefer to go with Daily Full Backup. My manager feels that going with Incremental Backup will save disk space.

If there is accidental deletion of data - we can restore it from Full Backup.
While in Differential Backup, i am not sure how we can restore in case of any data /table deletion ?

Whether Full Backup or Differential /Incremental Backup is best to go with ??
0
chokka
Asked:
chokka
4 Solutions
 
Seaton007Commented:
Incremental takes less space and less time to backup since it only backups up files that have changed since the last backup.  However, it take longer to do a restore as you would have to restore the last full backup, and then restore each incremental taken after that last full was taken.

Here is some more information regarding backup types: http://www.backup4all.com/kb/backup-types-115.html
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Yes, Differential Backup can help in saving some disk space.
If you have Incremental / Differential backup then you need to restore the last Full backup followed by the latest differential backup.

Please note that you need to restore Full Backup in No Recovery mode followed by last Differential backup or log backup in Recovery mode.

Differential backup can be extremely helpful if your database size is very huge.

More info:
http://smehrozalam.wordpress.com/2009/08/18/ssms-how-to-restore-differential-backups/
http://msdn.microsoft.com/en-us/library/ms175510.aspx
0
 
chokkaStudentAuthor Commented:
Let's say Database.bak - This file will grow on daily basis. ( Incremental Backup)

What will happen incase, if i delete a Table or Record, which i realized only after next day, In this scenario how will i restore the deleted Table / Record ??
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
chokkaStudentAuthor Commented:
You have not suggested which Backup i should go with ?? Either Incremental or Full Database Backup feature ?

All the comments are focused on merits of Incremental Backup !
0
 
Jared_SCommented:
Take a full backup every week with incremental backups on a frequent basis.
0
 
chokkaStudentAuthor Commented:
Full Backup on Weekly basis and Incremental Backup on Daily Basis ??
Because, i need to set up Job Scheduler on my SQL 2008 Database.
0
 
Jared_SCommented:
Just run two jobs.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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