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: 24020
Liked: 3255 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!

v.eremin
Product Manager
Posts: 16154
Liked: 1320 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL scheduled automated restore to another server

Post by v.eremin » 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: 5628
Liked: 1575 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
EMEA Cloud Architect @ Veeam Software

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

inoisikoiski
Influencer
Posts: 14
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: 17717
Liked: 1482 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: 14
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.

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Karinne, NiX and 27 guests