Forum Discussion

Sisso's avatar
Sisso
Level 5
12 years ago
Solved

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

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.

  • 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

5 Replies

  • 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

  • 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?

  • If you can remotely run commands/scripts on the client, it should start the .bch script on the client, not dbback.ex...
  • 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??

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