Veeam SQL Restores

Availability for the Always-On Enterprise

Veeam SQL Restores

Veeam Logoby ixiDUCKixi » Fri Jan 13, 2017 1:24 pm

Someone was mentioning today that it was possible to use SSMS to restore a SQL database from Veeam Backup & Recovery 9.0. I wasn't aware this was a feature, so I'd like to clarify if it's possible to have an SQL DBA use SSMS to restore an SQL database from B&R without engaging the Backup Administrators.
ixiDUCKixi
Lurker
 
Posts: 2
Liked: never
Joined: Thu Jan 12, 2017 10:00 pm

Re: Veeam SQL Restores

Veeam Logoby foggy » Fri Jan 13, 2017 9:42 pm

Could you please refer to where it was mentioned? Not sure, but probably that someone was talking about 1-Click FLR of the database file with further import via SQL Management Studio?
foggy
Veeam Software
 
Posts: 15295
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Veeam SQL Restores

Veeam Logoby ixiDUCKixi » Fri Jan 13, 2017 10:10 pm

It was mentioned in verbal conversation and went something like "I know for a fact that SQL can be restored from SSMS with Veeam B&R."

I hadn't heard of this before so I was researching to see if he was correct or not. So far, I don't think he was correct and this isn't a feature. It would be cool, but I don't know where he saw it or with what tool.

FLR might have been the way he did it....I'm not sure. I can talk to him again and get more info. Just thought i was missing something obvious in SSMS that would allow me to restore from B&R.
ixiDUCKixi
Lurker
 
Posts: 2
Liked: never
Joined: Thu Jan 12, 2017 10:00 pm

Re: Veeam SQL Restores

Veeam Logoby foggy » Fri Jan 13, 2017 10:19 pm

Native tools cannot deal with Veeam B&R backup files, you need to restore database files using some of the Veeam B&R restore options prior to be able to use native tools against them.
foggy
Veeam Software
 
Posts: 15295
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: arnaud.quenum, Google [Bot] and 1 guest