Host-based backup of VMware vSphere VMs.
Post Reply
CaptainPistache
Enthusiast
Posts: 34
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 »

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: 21070
Liked: 2115 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 » 1 person likes this post

Yes, you can do this, should work fine. Thanks!
CaptainPistache
Enthusiast
Posts: 34
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 »

Great, thanks for the reply !

Cheers,
Captain
Post Reply

Who is online

Users browsing this forum: No registered users and 62 guests