Comprehensive data protection for all workloads
Post Reply
frankive
Service Provider
Posts: 1092
Liked: 134 times
Joined: May 14, 2013 8:35 pm
Full Name: Frank Iversen
Location: Norway
Contact:

Export a SQL database to .bak files from Veeam Explorer

Post by frankive » 1 person likes this post

Feature request:
Be able to export a sql-database to .bak files from Veeam Explorer.
Most of our thir-part consulents prefer to have the backup delivered as a .bak
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by Vitaliy S. »

Hi Frank,

As a workaround you can always do local backups and then get these bak files via file level restore wizard even now.

Thanks!
Kostya
Veeam Software
Posts: 104
Liked: 28 times
Joined: Jun 18, 2012 9:38 am
Full Name: Kostya Yasyuk
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by Kostya »

frankive wrote:Feature request:
Be able to export a sql-database to .bak files from Veeam Explorer.
Most of our thir-part consulents prefer to have the backup delivered as a .bak
Frank, do you mean to have entire database in bak file, or just incremental log?
frankive
Service Provider
Posts: 1092
Liked: 134 times
Joined: May 14, 2013 8:35 pm
Full Name: Frank Iversen
Location: Norway
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by frankive »

Vityaly: yes i am aware of that and it is a ok workaround. just not 100%.. :)

Kostya: I would be happy if I could right click on a database in a veeam explorer and export it as a .bak file so I can send it to developers.
I am aware that i could just start a surebackup and then do it manually in the sql management studio. Though, that is 90% and not 100% intuitive.. :)
So not a very important request, but still, from a user perspective it would be great since many other backup vendor does actually always export it as a .bak file at restore too.
frankive
Service Provider
Posts: 1092
Liked: 134 times
Joined: May 14, 2013 8:35 pm
Full Name: Frank Iversen
Location: Norway
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by frankive »

is this something that is on roadmap? or is the workaround the future solution? just so I know if customers ask :)
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by Vitaliy S. »

Hi Frank, yes, we have noted this a feature request for our next releases. Thanks!
SteelContainer
Service Provider
Posts: 146
Liked: 21 times
Joined: May 21, 2014 8:47 am
Location: New Zealand
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by SteelContainer » 1 person likes this post

+1 on this request. This would be quite handy exporting to BAK. Also being able to restore a SQL database in NORECOVERY mode.
ahahum
Influencer
Posts: 21
Liked: never
Joined: Jul 26, 2010 8:01 pm
Full Name: Adam Bond
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by ahahum »

YES!! This is a question I just asked about - how to restore from a Veeam backup while retaining the ability to replay transaction logs to a point in time.

+1 for this feature.
Gostev
Chief Product Officer
Posts: 31457
Liked: 6648 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by Gostev »

ahahum wrote:how to restore from a Veeam backup while retaining the ability to replay transaction logs to a point in time
We provide this capability natively since v8?
zuerom
Novice
Posts: 8
Liked: 2 times
Joined: Feb 28, 2014 11:14 am
Full Name: Roman Zürcher
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by zuerom »

+1 this feature would be nice!
SteelContainer
Service Provider
Posts: 146
Liked: 21 times
Joined: May 21, 2014 8:47 am
Location: New Zealand
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by SteelContainer »

Gostev wrote: We provide this capability natively since v8?
Yes that's true you can do this when all backups are taken with Veeam however there are situations where a SQL DB may have been backed up by another method for some reason.

For example we had a situation where the full backup of a database was taken by Veeam. A user restored over the wrong database but they had fortunately\unfortunately made a tail-log backup with SQL as part of there restore. It's possible to replay this log if you have the original full backup in BAK or you if can restore in NORECOVER mode. Veeam can only perform the full consistent restore AFAIK.
jcapone
Influencer
Posts: 15
Liked: 1 time
Joined: Mar 01, 2016 9:28 pm
Full Name: John Capone
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by jcapone »

I have not been able to find this feature. How do we access it? I don't see .bak file indicated in any of the export options in SQL Explorer.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by foggy »

Hi John, which feature are you referring to? This thread is discussing a feature request to export database as a .bak file, currently this functionality is not available.
jcapone
Influencer
Posts: 15
Liked: 1 time
Joined: Mar 01, 2016 9:28 pm
Full Name: John Capone
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by jcapone »

Yes that's the feature I was referring to. I thought a prior reply stated that this capability was supported starting in v8 but maybe I was misinterpreting. This feature would be very helpful, for the same reasons the other respondents have stated. Thanks for the prompt reply!
paallergy
Enthusiast
Posts: 51
Liked: 10 times
Joined: May 18, 2010 7:10 pm
Full Name: Jonathan Schultz
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by paallergy »

I do local SQL Server backups using scripts from https://ola.hallengren.com.
One advantage is knowing exactly how SQL Server backups are done
I backup with the VM with Veaam B&R.
On a regular basis I use FLR to copy file .BAK file and test the backup.
(Yes, I know about SureBackup and also use SureBackup)
tknaller
Influencer
Posts: 14
Liked: 1 time
Joined: Jun 01, 2017 9:00 am
Full Name: Thomas Knaller
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by tknaller »

+1 for the feature to export from veeam backup directly to .bak (for sending to developers)
yakamoneye18
Enthusiast
Posts: 54
Liked: 7 times
Joined: May 03, 2018 6:20 am
Full Name: Tobias
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by yakamoneye18 »

+1 for this feature from me, too. At the moment our ERP Admin is using the hourly created DB backup to refresh his local test system from time to time. Since we are going to switch from native backup to Veeam Transaction Log Backup soon, this would eliminate the additional step of creating a db dump manualy.
t481
Enthusiast
Posts: 82
Liked: 1 time
Joined: Apr 28, 2015 7:52 am
Contact:

Re: Export a SQL database to .bak files from Veeam Explorer

Post by t481 »

+1 for this feature as well
Post Reply

Who is online

Users browsing this forum: ante_704, Bing [Bot], Google [Bot], JTT, vtsybin and 257 guests