cancel
Showing results for 
Search instead for 
Did you mean: 

ASE backup server check

Former Member
0 Kudos

Hello gentleman,

I have got simple question regarding ASE backup server.

I know that you can check it manually in error log, but he needs sp.

Our CT wants to monitor if backup server is up and down. For this purpose needs any stored procedure which returns 2 values 1 when it is up and 0 when it is down.

Is there any stored procedure within ASE which returns actual status of backup server?

Marian

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

SYB_BACKUP...sp_ps

SYB_BACKUP...sp_who

Former Member
0 Kudos

Ajay at the moment I am using

SYB_BACKUP...sp_who

which generates error in log I can use in other tool to automate the process.

Marian

Former Member
0 Kudos

Typically there are 2 things you can do -

1st is to perform a dump of a tiny database - e.g. model. This will take practically no time at all, and you can verify backupserver is up depending on the dump success/failure (@@error). You can code the backup in a sproc and return an appropriate status.

2nd is outside ASE (not what you asked, I know but...) where you can use isql to login to the backupserver (username and password don't matter) and the return code ($?) of isql tells you whether it can login or not. Perhaps you can code this as an SP througf XP Server if that's an option?

Other than that, I can't think of an SP you can use.

Hope that helps,

Antony.