Backup SQL Server 2000 database on one server remotely from another server.
Posted on 2007-04-05
I have two SQL Servers 2000: ServerA and ServerB. They both linked to each other. On ServerA I created a Stored Procedure spBackupDBOnServerA that backups DB locally; this DB is 16GB in size. On ServerB I created a job that executes spBackupDBOnServerA on ServerA; this job fails with this error:
Executed as user: domain\user_name. Could not relay results of procedure 'spBackupDBOnServerA' from remote server 'ServerA'. [SQLSTATE 42000] (Error 7221) [SQLSTATE 01000] (Error 7312). The step failed.
I've searched on the internet, but had no luck.
Any help appreciated.