Incremental level backup - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Incremental level backup

Author

Topic

dsharma
Starting Member

4 Posts

Posted - 2011-01-17 : 23:34:17

Hi All,

Can anyone tell me how we can take incremental level backup in SQL Server? Is is necessary to have zero or full backup earlier before taking incremental level backup as in Oracle we do.

Thanks
Deepak

Deepak Sharma
D.B.A

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-18 : 00:59:30

SQL doesn't have incremental backups.

If you're talking about differential backups, you need to have run a full backup and then the diff is based on that full backup.

--
Gail Shaw
SQL Server MVP

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-01-18 : 05:36:06

quote:
SQL doesn't have incremental backups.

Well...net really true is it? Translog backups are incremental... But you'd still need to have a full backup first.

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

dsharma
Starting Member

4 Posts

Posted - 2011-01-18 : 06:08:57

Thanks everyone for the reply. doubts cleared.

Regards
Deepak

Deepak Sharma
D.B.A

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-18 : 07:17:12

quote:
Originally posted by Lumbago

quote:
SQL doesn't have incremental backups.
Well...net really true is it? Translog backups are incremental... But you'd still need to have a full backup first.

No. Transaction log backups are transaction log backups. They don't behave like incremental backups (eg NTBackup). An incremental backup is a backup of the net changes since the previous incremental, differential or full backup. Log backups are records of all operations since the previous log backup and are not based on a particular full or diff backup unless the log chain was broken.

Calling transaction log backups incremental backups just confuses people, especially people familiar with incremental backups from other products.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources