Grab SQL .BAK files

VMware specific discussions

Grab SQL .BAK files

Veeam Logoby Zew » Wed 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?
Zew
Expert
 
Posts: 173
Liked: 39 times
Joined: Tue Mar 17, 2015 9:50 pm
Full Name: Aemilianus Kehler

Re: Grab SQL .BAK files

Veeam Logoby PTide » Thu 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
PTide
Veeam Software
 
Posts: 3019
Liked: 246 times
Joined: Tue May 19, 2015 1:46 pm

Re: Grab SQL .BAK files

Veeam Logoby foggy » Thu 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?
foggy
Veeam Software
 
Posts: 14728
Liked: 1077 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Grab SQL .BAK files

Veeam Logoby Zew » Thu 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..
Zew
Expert
 
Posts: 173
Liked: 39 times
Joined: Tue Mar 17, 2015 9:50 pm
Full Name: Aemilianus Kehler

Re: Grab SQL .BAK files

Veeam Logoby PTide » Fri 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
PTide
Veeam Software
 
Posts: 3019
Liked: 246 times
Joined: Tue May 19, 2015 1:46 pm

Re: Grab SQL .BAK files

Veeam Logoby Zew » Mon 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?
Zew
Expert
 
Posts: 173
Liked: 39 times
Joined: Tue Mar 17, 2015 9:50 pm
Full Name: Aemilianus Kehler

Re: Grab SQL .BAK files

Veeam Logoby PTide » Mon 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
PTide
Veeam Software
 
Posts: 3019
Liked: 246 times
Joined: Tue May 19, 2015 1:46 pm


Return to VMware vSphere



Who is online

Users browsing this forum: Yahoo [Bot] and 25 guests