Veeam SQL Plug in Restore Script

[brengan]

Hello,

At the moment we use a different backup product for database backups and Veeam for VM level backup and are testing the new V12 SQL Plug in. We are already using Application Aware processing at the VM Guest level backup job to included consistent copy of the SQL databases and it is working OK. We would like to use the SQL Plug in based backup and restore for the databases as it offers more flexibility than the application aware processing.

For Disaster Recovery purpose, we would like to test the restore procedure using SQL Plug in based backups to a specific point in time. Note that the point in time for the database restore could be different from the VM image backup timing. The SQL Agent jobs are working OK for doing the backup. When it comes to restore of all databases on a SQL Server instance, is there a way we can script out the job like how we are able to for the backup? If a SQL Server instance has 30 different databases, it may not be practical to write a DR procedure to go through the restore wizard for each database separately. PowerShell could be an option to do some custom scripting with MSSQLRecoveryManager.exe command line to code restore for each database. Before going down the path of doing custom scripting, I would like to understand what options we have to automate SQL database restore with plug in based backups.

Thanks
BR

[Andreas Neufert]

The Veeam Plug-in for SQL has a command line interface:
https://helpcenter.veeam.com/docs/backu ... ml?ver=120
You can as well go to the wizard and click everything that you need and then let you show the script.
There is a "Script" link on top of each SQL Plug-in wizard that allows you to copy it. The script runs on the SQL server but you can login with powershell or other tools remotely to start this I guess. As well you can use SQL native Agent to schedule things like a frequent QA system update.


For the image level backup, the Explorer based restore can be executed with Veeam Powershell:
https://helpcenter.veeam.com/docs/backu ... ml?ver=120
Here is a sample:
powershell-f26/how-to-get-as-close-to-a ... 62360.html