SYB_BACKUP...sp_who does not return any results

[DilipVoora]

Hi Experts,

When we are trying to execute SYB_BACKUP..sp_who(Sloaris 5.8, ASE 15.5) and getting the below message in bold. I have run it on another server with the same version of software on the same platform and we got the required results.Also we stopped and restarted the backup server but this made no difference. Please advise.

1> SYB_BACKUP..sp_who
2> go
Msg 911, Level 11, State 2:
Server 'dev_aros', Line 1:
Attempt to locate entry in sysdatabases for database 'SYB_BACKUP' by name failed - no entry found under that name. Make sure that name is entered properly.

1> sp_helpserver
2> go
name network_name class status id cost
---------- --------------- ------------ -------------------------------------------------------------------------------------------------- -- ----
SYB_BACKUP BACKUP_dev_aros ASEnterprise no timeouts, no net password encryption, writable , rpc security model A, enable login redirection 5 1000
SYB_EJB EJBServer ASEJB external engine auto start, enable login redirection 2 NULL
dev_aros dev_aros local 0 0
dev_yld dev_yld ASEnterprise no timeouts, no net password encryption, writable , rpc security model A, enable login redirection 3 1000
loopback dev_aros ASEnterprise no timeouts, no net password encryption, writable , rpc security model A, enable login redirection 6 1000
whq_dev1 whq_dev1 ASEnterprise no timeouts, no net password encryption, writable , rpc security model A, enable login redirection 4 1000
(return status = 0)

NOTE: Database backups are not happening as we got them scheduled through cron.

Regards, Dilip

[DilipVoora]

Hello Bret,

Thanks for the correction. We have tried SYB_BACKUP...sp_who and now we are not getting anything. Please find the details in the attachment provided.

Regards, Dilip

[former_member188958]

Hi Dilip,

Your qualified object name only has three fields, so "SYB_BACKUP"
is being interpreted as a database name, rather than a server name.

Use three periods between SYB_BACKUP and sp_who::

SYB_BACKUP...sp_who

-bret