Skip to Content
avatar image
Former Member

SYB_BACKUP...sp_who does not return any results

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 02, 2016 at 09:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2016 at 01:58 PM

    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

    Add comment
    10|10000 characters needed characters exceeded