August 1, 2002 at 12:11 pm
Hi all
Using DevEd SS2k (no service packs). Setup a bog standard linked server to another named instance running on the same box. For some strange reason I am getting the error below:
exec standbyserver.master.dbo.StandbyServer_restore_full_database_backup
Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'master.dbo.StandbyServer_restore_full_database_backup'.
Server: Msg 7221, Level 18, State 2, Line 1
Could not relay results of procedure 'StandbyServer_restore_full_database_backup' from remote server 'standbyserver'.
remotely calling sp_helpdb etc works fine. Ive drawn a blank here.
ideas?
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 1, 2002 at 12:13 pm
Ok
Worked it out. I was using an alias in the linked server to the other named instance on the same box, I altered this to the actual named instance name and now works fine.
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply