Is it possible to restore a database on a server, using a script on another server?
For example, I have a server A and a server B and I want to restore a database foo on server B from within a script on server A.
I was thinking of something like this:
RESTORE DATABASE B.foo FROM DISK ..., but I can't find any information about it.
And I'm looking for something similar for BACKUP DATABASE too.