Comprehensive data protection for all workloads
Post Reply
wa15
Veteran
Posts: 323
Liked: 25 times
Joined: Jan 02, 2014 4:45 pm
Contact:

Renaming and Restoring SQL DB (Possible feature request?)

Post by wa15 »

Veeam Community -

We are trying to see how we can restore SQL Databases from our backups into dev boxes using a different name. In other words, we are trying to take a SQL DB that was backed up from Veeam, restore it using a different name to a different (or same) SQL server. How is this possible? Currently running V7.

We currently don't have the virtual labs or surebackups configured, and am looking to get that configured though it looks rather confusing.

I know that there will be a SQL Explorer in v8 and am looking forward to that, but will what we are trying to do above be in v8 AND is it possible to do this in v7?

Thanks,
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Renaming and Restoring SQL DB (Possible feature request?

Post by Vitaliy S. »

Hi Farshid,

You can use FLR wizard to pull database files from the backups and restore them to the required SQL Server.

Thanks!
wa15
Veteran
Posts: 323
Liked: 25 times
Joined: Jan 02, 2014 4:45 pm
Contact:

Re: Renaming and Restoring SQL DB (Possible feature request?

Post by wa15 »

Got it. We were able to export the MDF and logs from FLR and just attach it using the SQL Studio Management. Is that how you would have done it too?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Renaming and Restoring SQL DB (Possible feature request?

Post by foggy »

Yes, this is the most straightforward way with v7.
wa15
Veteran
Posts: 323
Liked: 25 times
Joined: Jan 02, 2014 4:45 pm
Contact:

Re: Renaming and Restoring SQL DB (Possible feature request?

Post by wa15 »

Thank you sir. We switched over from Commvault Simpana and were used to being able to restore SQL databases directly from the Simpana interface. Is that something that will be added in future versions so we don't need to use SQL management studio?
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Renaming and Restoring SQL DB (Possible feature request?

Post by Vitaliy S. »

Yes. Check out what's coming in our v8 for SQL restores > http://www.veeam.com/blog/the-veeam-exp ... d-sql.html
Post Reply

Who is online

Users browsing this forum: Bing [Bot], Semrush [Bot], tyler.jurgens and 198 guests