Comprehensive data protection for all workloads
Post Reply
JasonPGTF
Influencer
Posts: 11
Liked: never
Joined: Sep 19, 2018 1:29 am
Full Name: Jason Oon
Contact:

Backing up SQL databases only

Post by JasonPGTF » Dec 18, 2018 8:02 am

Hi, are Veeam capable of performing only SQL database backups instead of taking the entire server snapshots?
I'm in the midst of comparing 2 backups solutions to decide if I should move my SQL database from current backup solution to Veeam. This questions actually applies to both physical & VM servers.

Currently I notice that Veeam usually did a backup of the whole VM snapshot image which means the size of the backups are relatively large as it includes the OS as well as the application SQL database. Is it possible for Veeam to purely do a backup of the SQL database only? My current backup solution is running backups purely for SQL application thus the backup & restore timing is faster as it focus only on the application.

DGrinev
Veeam Software
Posts: 1722
Liked: 218 times
Joined: Dec 01, 2016 3:49 pm
Full Name: Dmitry Grinev
Location: St.Petersburg
Contact:

Re: Backing up SQL databases only

Post by DGrinev » Dec 18, 2018 10:36 am

Hi Jason,

You cannot back up only SQL application, as Veeam B&R is image-level backup solution.
However, you should keep in mind that Veeam B&R provides you ability to select even a specific transaction to restore the database up to and also allows the restore of a particular database schema objects and tables data. Thanks!

foggy
Veeam Software
Posts: 18122
Liked: 1536 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backing up SQL databases only

Post by foggy » Dec 18, 2018 12:23 pm 1 person likes this post

Hi Jason, you can achieve what you want with the help of Veeam Agent for Windows.

RubinCompServ
Service Provider
Posts: 86
Liked: 14 times
Joined: Mar 16, 2015 4:00 pm
Full Name: David Rubin
Contact:

Re: Backing up SQL databases only

Post by RubinCompServ » May 02, 2019 3:03 pm

foggy,

Based on that article, it looks like it's just using the SQL Processing component of the Agent to backup up the SQL logs. How is that any different from just configuring that same setting within a regular backup job within VBR?

foggy
Veeam Software
Posts: 18122
Liked: 1536 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backing up SQL databases only

Post by foggy » May 08, 2019 11:53 am

Veeam B&R will perform an image-level backup of the entire VM, while Veeam Agent for Windows allows you to perform file-level backup of the database files with transaction logs backup.

RubinCompServ
Service Provider
Posts: 86
Liked: 14 times
Joined: Mar 16, 2015 4:00 pm
Full Name: David Rubin
Contact:

Re: Backing up SQL databases only

Post by RubinCompServ » May 08, 2019 12:51 pm

I'm sorry, I still don't understand. All of the settings listed in Step #7 of your article are also available in VBR, and seem to do the same thing.

Dima P.
Product Manager
Posts: 10426
Liked: 844 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Backing up SQL databases only

Post by Dima P. » May 31, 2019 3:29 pm

David,

Foggy was referring to Veeam Agent's ability to process databases as files via file level backup mode without taking the entire machine backup. With VM backup there is no way to process only database files, so you must backup entire VM. Makes sense?

RubinCompServ
Service Provider
Posts: 86
Liked: 14 times
Joined: Mar 16, 2015 4:00 pm
Full Name: David Rubin
Contact:

Re: Backing up SQL databases only

Post by RubinCompServ » May 31, 2019 4:45 pm

Dima,
Now I get it. Thanks!

hightech
Lurker
Posts: 1
Liked: never
Joined: Oct 19, 2018 9:05 am
Full Name: Cihan Tayiz

[MERGED] SQL Database backup

Post by hightech » Aug 09, 2019 1:15 pm

Hello,

is it possible to backup only a SQL database ?
I would like to backup a SQL database without the whole virtual maschine every 4 hours.
At the moment it is the case that the whole machine will backup.

Thanks.

foggy
Veeam Software
Posts: 18122
Liked: 1536 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backing up SQL databases only

Post by foggy » Aug 09, 2019 1:42 pm 1 person likes this post

Hi Cihan, yes, this is possible with Veeam Agent for Windows. Please see above. Thanks!

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 28 guests