SQL Refresh Test Environment

[slevchenko]

Hello,

I'm reading that I might have to wait until the next version of Veeam B&R, but I wanted to float the question anyways.

BACKGROUND: I am attempting to automatically refresh my SQL test environment using Veeam.

QUESTION: Is it possible to script out a restore of a SQL database with the following conditions?

• Different destination server (a test server)

• Different destination drive letters

• Overwrite any databases with the same name (even though it is on a different server)

I found that using the GUI, if I attempt to restore a database to a different server, and I click Yes to "delete destination database" when asked, it still gets stuck if an MDF or LDF of the same file name exists on the test box. I verified with tech support that this is an expected behavior.

I'm running 9.5 v1922.

Thanks,
Steve

[veremin]

Ability to restore SQL db to different server while giving different names of .mdf and .ldf files via PowerShell is included in Update 4; so, stay tuned!