Discussions specific to the VMware vSphere hypervisor
Post Reply
CaptainPistache
Enthusiast
Posts: 31
Liked: 2 times
Joined: Nov 30, 2017 9:42 am
Location: Switzerland
Contact:

[MS SQL Server] Restore a prod DB to a test DB on the same server

Post by CaptainPistache » Sep 20, 2018 12:54 pm

Hello Veeam Community,

Almost everything is in the title :
About once per month, we need to restore the prod DB on the test DB residing on the same SQL Server (2012) and I'd like to make sure to know how to do it the right way before actually doing it.

In my opinion, I should use the "Restore on another server" option through the SQL Veeam Explorer and then just select the same server name but change the database name from prod to test.
Is that correct ?

Thanks a lot for your help in advance.

Captain

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

Re: [MS SQL Server] Restore a prod DB to a test DB on the same server

Post by foggy » Sep 21, 2018 4:47 pm 1 person likes this post

Yes, you can do this, should work fine. Thanks!

CaptainPistache
Enthusiast
Posts: 31
Liked: 2 times
Joined: Nov 30, 2017 9:42 am
Location: Switzerland
Contact:

Re: [MS SQL Server] Restore a prod DB to a test DB on the same server

Post by CaptainPistache » Sep 24, 2018 3:25 pm

Great, thanks for the reply !

Cheers,
Captain

Post Reply

Who is online

Users browsing this forum: Baidu [Spider] and 15 guests