Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
oshvitzon1
Novice
Posts: 5
Liked: never
Joined: Aug 02, 2017 3:31 pm
Full Name: Ben Erez
Contact:

Feature Request : SQL incremental or differential Backup

Post by oshvitzon1 »

Hi ,
as i understand SQL is being backed up by VSS as full file DB every backup , there should be an option to use the default SQL server backup mechanism for differential backups and a pre-configured set ,
for example : 1 day Full Backup + 6 days differential backup.
that way backup data transferred during week days will be smaller without compromising backed up data integrity.

Cheers
ben
Ben erez
Churchill Computers - IL
Dima P.
Product Manager
Posts: 14727
Liked: 1707 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Feature Request : SQL incremental or differential Backup

Post by Dima P. »

Hi oshvitzon1,

Actually, it depends on backup mode you are running. In case of file level backup changed file is backed up again. When you use Entire PC backup or Volume level backup we perform change block tracking and backup only changed blocks, so image level backup provides a true incremental backup.
oshvitzon1
Novice
Posts: 5
Liked: never
Joined: Aug 02, 2017 3:31 pm
Full Name: Ben Erez
Contact:

Re: Feature Request : SQL incremental or differential Backup

Post by oshvitzon1 »

i mostly back up file level because of bandwidth and storage issues.
a native sql backup option would allow differential also on File level backup , shouldn't be much of a problem as it is a basic SQL script.
current situation is a full backup every time :-(
Ben erez
Churchill Computers - IL
Dima P.
Product Manager
Posts: 14727
Liked: 1707 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Feature Request : SQL incremental or differential Backup

Post by Dima P. »

Ben,

Thanks for sharing the details. Yes, when we speak about file level backup this behavior is expected so I’ve added you vote to a feature request for potential improvement of the file level backup.
Post Reply

Who is online

Users browsing this forum: No registered users and 16 guests