Comprehensive data protection for all workloads
Post Reply
phil987AQ
Novice
Posts: 4
Liked: never
Joined: Dec 14, 2016 7:47 pm
Full Name: Phil Bailey
Contact:

SQL scheduled automated restore to another server

Post by phil987AQ » Dec 14, 2016 8:08 pm

Hello
I wanted to know if this feature is coming soon? I'm looking for automated sql restores to another server. For example production databases to dev after nightly backup every day.
Thanks
Phil

Gostev
SVP, Product Management
Posts: 24308
Liked: 3335 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL scheduled automated restore to another server

Post by Gostev » Dec 15, 2016 2:13 am

Hi, Phil

This feature is already available through PowerShell.

Thanks!

veremin
Product Manager
Posts: 16554
Liked: 1379 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL scheduled automated restore to another server

Post by veremin » Dec 15, 2016 10:16 am

Check this section of our User Guide for more information. Use -ServerName parameter to restore to different server. Thanks.

dellock6
Veeam Software
Posts: 5680
Liked: 1601 times
Joined: Jul 26, 2009 3:39 pm
Full Name: Luca Dell'Oca
Location: Varese, Italy
Contact:

Re: SQL scheduled automated restore to another server

Post by dellock6 » Dec 15, 2016 8:04 pm

you may want to have a look at this awesome post from my colleague Preben Berg, sounds like what you are looking for:
https://poulpreben.com/refresh-sql-data ... velopment/
Luca Dell'Oca
Principal EMEA Cloud Architect @ Veeam Software

@dellock6
https://www.virtualtothecore.com/
vExpert 2011 -> 2019
Veeam VMCE #1

inoisikoiski
Influencer
Posts: 17
Liked: never
Joined: Apr 12, 2019 9:55 am
Full Name: Inoi Visp
Contact:

Re: SQL scheduled automated restore to another server

Post by inoisikoiski » Apr 12, 2019 10:14 am

Hi,
Is there a script as well for sql object restore? The script is basically for developers who doesn't have admin rights and would like to do an object restore.
Thanks
Inoi

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

Re: SQL scheduled automated restore to another server

Post by foggy » Apr 12, 2019 4:09 pm

Hi Inoi, I don't think objects restore is available in PS.

inoisikoiski
Influencer
Posts: 17
Liked: never
Joined: Apr 12, 2019 9:55 am
Full Name: Inoi Visp
Contact:

Re: SQL scheduled automated restore to another server

Post by inoisikoiski » Apr 15, 2019 8:16 am

Thanks foggy.

carruzzom
Lurker
Posts: 1
Liked: never
Joined: May 29, 2019 7:45 am
Contact:

Re: SQL scheduled automated restore to another server

Post by carruzzom » May 29, 2019 7:59 am

Hi everyone,

I've tried this script but unfortunately with the new version of Veeam to command is obsolete :(

WARNING: This cmdlet is obsolete, use Get-VESQLDatabase instead

I don't find a way to adapt the script correctly. Do you have by any chance an upgraded version of this script ?

Thanks in advance
Best regards

Matt

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 26 guests