Comprehensive data protection for all workloads
Post Reply
ixiDUCKixi
Lurker
Posts: 2
Liked: never
Joined: Jan 12, 2017 10:00 pm
Contact:

Veeam SQL Restores

Post by ixiDUCKixi »

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.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam SQL Restores

Post by foggy »

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?
ixiDUCKixi
Lurker
Posts: 2
Liked: never
Joined: Jan 12, 2017 10:00 pm
Contact:

Re: Veeam SQL Restores

Post by ixiDUCKixi »

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.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam SQL Restores

Post by foggy »

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.
Post Reply

Who is online

Users browsing this forum: ante_704, rweis and 265 guests