Comprehensive data protection for all workloads
Post Reply
frankive
Service Provider
Posts: 919
Liked: 107 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 » Jul 16, 2015 12:07 pm 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.
Product Manager
Posts: 23410
Liked: 1665 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. » Jul 16, 2015 12:40 pm

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 » Jul 16, 2015 1:03 pm

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: 919
Liked: 107 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 » Jul 16, 2015 1:16 pm

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: 919
Liked: 107 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 » Jul 23, 2015 4:25 pm

is this something that is on roadmap? or is the workaround the future solution? just so I know if customers ask :)

Vitaliy S.
Product Manager
Posts: 23410
Liked: 1665 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. » Jul 23, 2015 5:36 pm

Hi Frank, yes, we have noted this a feature request for our next releases. Thanks!

Cullan
Service Provider
Posts: 107
Liked: 14 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 Cullan » Feb 10, 2016 9:15 pm 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 » Feb 10, 2016 9:30 pm

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
SVP, Product Management
Posts: 25530
Liked: 3874 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 » Feb 11, 2016 1:16 am

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 » Feb 11, 2016 9:28 am

+1 this feature would be nice!

Cullan
Service Provider
Posts: 107
Liked: 14 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 Cullan » Feb 14, 2016 9:30 pm

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: 13
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 » Jan 26, 2018 4:37 pm

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: 18666
Liked: 1631 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 » Jan 26, 2018 5:50 pm

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: 13
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 » Jan 26, 2018 6:52 pm

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: 35
Liked: 6 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 » Jan 28, 2018 4:25 am

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 » Mar 05, 2018 1:53 pm

+1 for the feature to export from veeam backup directly to .bak (for sending to developers)

yakamoneye18
Enthusiast
Posts: 37
Liked: 3 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 » Jun 04, 2018 9:12 am

+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: 62
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 » Aug 10, 2018 1:03 pm

+1 for this feature as well

Post Reply

Who is online

Users browsing this forum: Google [Bot], mkretzer and 23 guests