Backing Up Database Specifying Server Name

[apc2003]

We have a Stored Procedure that backs up specified databases stored on a single Server.

We need to be able to run this stored procedure that is stored on Server 1 and backup a database on server 2.

Prefixing the Database with the server name errors... complaining that the Name doesn't exist in the 'sysdatabases' table.

Can anyone suggest some syntax for making this work?

Thanks in advance...

 

[NoCoolHandle]

Backups are supposed to be run from the server that you are backing up. Doing a backup via serverX won't work unless you are logged onto serverX

What you might want to do is setup a task or proc on Server2 that does a backup on SErver2 but places the backupfile on Server1. Then you could call the proc from server 1 that causes the backupprocess on server2 to begin and ends up leaving the file on server1

Hope that makes sence

Rob