Sisso
12 years agoLevel 5
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