SQL object level restore using PS

[inoisikoiski]

Hello,
Just wondering whether there's a script to do a sql object level restore please.
Thanks

[HannesK]

Hello,
all available powershell cmdlets for SQL Explorer can be found in https://helpcenter.veeam.com/docs/backu ... l?ver=95u4 . Could you specify what kind of "objects" you mean?

If databases, that's possible with Restore-VESQLDatabase

Best regards,
Hannes

[inoisikoiski]

Thanks Hannes. What I meant by sql object level restore is such as tables, stored procedures, etc. I got a response previously from foggy on a similar post and he said there is no script to do a sql object level restore

[HannesK]

sorry, if foggy says so, then it is the way it is... he knows these things

[veremin]

Correct, you cannot restore SQL items, such as tables, procedures, etc. using PowerShell. Thanks!

[inoisikoiski]

Cheers!

[tsightler]

I wouldn't say you cannot do it, I'd say you cannot do it with Veeam Powershell. However, you can use Publish-VESQLDatabase and then use standard SQL tools to copy whatever you want. Personally, for copying tables, I highly recommend the dbatools Powershell module:

https://github.com/sqlcollaborative/dbatools

They have a nice command, Copy-DbaDbTableData, which makes copying tables between databases quite easy and fast using BCP. For stored procedures or other, more complex objects and relationships, you might have to get a little more creative, but there are plenty of examples for all of these because it's no different than copying between any two databases.