Skip to Content
0

SYB_BACKUP...sp_who does not return any results

Nov 02, 2016 at 09:02 PM

75

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Bret Halford
Nov 02, 2016 at 09:14 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Dilip Voora Nov 03, 2016 at 01:58 PM
0

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


a0c2t.png (64.1 kB)
Share
10 |10000 characters needed characters left characters exceeded