How to start a restore of sql DB from media server to a remote sql server

[Sisso]

Hi,

There is any way to make a backup or restore from a media server to every DB in any sql client in my environment?

I know about the command dbbackex.exe, unfortunately it obey me to run it from the sql client.

Thank you for any help.

[Mark_Solutions · Accepted solution]

For backups you should use a policy - you need one available anyway to have the backup actually run

If you need to script it then you can just run the bpbackup -i command to kick the policy off (same as a right click "manual backup" on a policy.

Restores need to be initiated from the client - or at least the script developed from the original client and then run on an alternate client

Hope this helps

[Sisso]

Thank you for the answer Mark,

but I wondering, if I will run with psexec to client the dbbackex.exe -f command from my media server, it sould be work?

[Marianne]

If you can remotely run commands/scripts on the client, it should start the .bch script on the client, not dbback.ex...

[Sisso]

Hi Marianne,

Do you know if I create script template from Netbackup MS SQL client, how can I run it remotely on clients' without use the dommand dbbackex.exe??

[Marianne]

I have never tried this, but my first attempt would be to simply run the .bch script, providing the full path.