November 27, 2014 at 1:50 am
Can anybody brief about incremental backup? when it will be used?
November 27, 2014 at 2:12 am
SQL Server doesn't have incremental backups.
It has full database backups, differential database backups and log backups. Which are you asking about?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2014 at 10:11 am
The differential backup will be used only if you specify it yourself for backups. It won't automatically run unless you set it up. The differential will only backup changes to the database since the last full backup, making it a faster option on systems with a high load. But, it makes recovery longer because you have to restore the full backup and the differential. If you do use differentials, make sure you still take full backups regularly and don't lose those because the differentials depend on it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 12, 2014 at 2:59 am
Dear Shreekant,
SQL Server has following 3 types of backup:
1.Full backup
2.Differential backup
3.Transaction log backup
Full backup takes backup of complete data and log file upto that time.
Differential backup takes backup of all data changes since the last full backup.
Transaction log backup works in the form of a continuous chain. After full backup transaction log backups can be scheduled such that they form a continuous chain.
Probably when you say incremental you meant Differential.. 🙂
Regards
Shafat Husain
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply