Discussions specific to the VMware vSphere hypervisor
Post Reply
Zew
Expert
Posts: 214
Liked: 42 times
Joined: Mar 17, 2015 9:50 pm
Full Name: Aemilianus Kehler
Contact:

Grab SQL .BAK files

Post by Zew » Sep 28, 2016 9:11 pm

Hey guys,

So I had a bit of a debate with my DBA... He wants to keep his Native SQL backups (From SQL server to a simple separate storage unit, we use as basic storage for whatever)

I recently had to make a bunch of system, network, and storage changes, and this required me to move this repo, his native backups were 800Gigs well over 85% of the repo.

I checked this out. https://helpcenter.veeam.com/backup/how ... rview.html

Currently AAP is enabled on our SQL server backup job. His primary reason was working with .BAK files (native SQL backup extention.)

Is it possible to get this from my SQL backups from Veeam?

P.Tide
Product Manager
Posts: 5264
Liked: 459 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Grab SQL .BAK files

Post by P.Tide » Sep 29, 2016 10:49 am

Hi,

So, you want to get a .bak file out of Veeam backup, is that correct? If that's the case then you can perform instant recovery of a VM and then run SQL native backup inside that VM and grab the resulting .bak

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

Re: Grab SQL .BAK files

Post by foggy » Sep 29, 2016 11:06 am

And what does he do with the .bak files? Any chance Veeam Explorer for SQL Server could provide more extensive functionality?

Zew
Expert
Posts: 214
Liked: 42 times
Joined: Mar 17, 2015 9:50 pm
Full Name: Aemilianus Kehler
Contact:

Re: Grab SQL .BAK files

Post by Zew » Sep 29, 2016 10:19 pm

Thanks PTide!

Good idea!

Foggy, unno... makes him feel warm inside. I said the sme thing, even the last time he needed something with granular accuracy it came right back to my Veeam backups anyway.

I'll just make this write for him to be able to grab these files that way, he just wanted a most recent .BAK file always on hand for I guess the native restore options of SQL. I brought up the same thing, why do use manually when we have paid support third party product which does all the work and has been tried and tested and proven. Veeam just works..

P.Tide
Product Manager
Posts: 5264
Liked: 459 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Grab SQL .BAK files

Post by P.Tide » Sep 30, 2016 10:06 am

Another argument is that transaction log backup feature makes it possible to create .bak for any arbitrary point it time/transaction.

Thanks

Zew
Expert
Posts: 214
Liked: 42 times
Joined: Mar 17, 2015 9:50 pm
Full Name: Aemilianus Kehler
Contact:

Re: Grab SQL .BAK files

Post by Zew » Oct 03, 2016 2:50 pm

PTide, but the only was is via the way you mentioned in your initial reply by doing an instant recovery and then run SQL native backup inside that VM and grab the resulting .bak

Or is there a nicer way to do it direct from Veeam?

P.Tide
Product Manager
Posts: 5264
Liked: 459 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Grab SQL .BAK files

Post by P.Tide » Oct 03, 2016 3:01 pm

I meant that if you need .bak for some particular transaction you can perform Instant Recovery of the VM with a subsequent restore to point in time or restore to specific transaction operation and then get .bak for that specific point in time.

Thanks

Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests