Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How to get backup server error log file location

3 posts in General Discussion Last posting was on 2009-06-02 08:46:59.0Z
sri Posted on 2009-06-01 07:27:33.0Z
Sender: 5991.4a2381e1.1804289383@sybase.com
From: sri
Newsgroups: sybase.public.ase.general
Subject: How to get backup server error log file location
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a2382e5.59a6.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 1 Jun 2009 00:27:33 -0700
X-Trace: forums-1-dub 1243841253 10.22.241.41 (1 Jun 2009 00:27:33 -0700)
X-Original-Trace: 1 Jun 2009 00:27:33 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27802
Article PK: 77053

select @@errorlog

will give us ASE server error log file location. Is there
any way to get backup server error log file location.


J Posted on 2009-06-01 17:17:09.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: How to get backup server error log file location
Reply-To: J@bogusemailAddress.com
Message-ID: <4a240ca2.8273757@forums.sybase.com>
References: <4a2382e5.59a6.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 1 Jun 2009 10:17:09 -0700
X-Trace: forums-1-dub 1243876629 10.22.241.152 (1 Jun 2009 10:17:09 -0700)
X-Original-Trace: 1 Jun 2009 10:17:09 -0700, vip152.sybase.com
Lines: 55
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27805
Article PK: 77056

On 1 Jun 2009 00:27:33 -0700, sri wrote:

I am guessing that you want to do this from an ASE command. You
possibly could do something with xp_cmdshell if you know some things.

e.g. (or maybe a "ps" command if the backup server is running from
xp_cmdshell).

1> xp_cmdshell "grep log RUN_SYB_BACKUP.bat"
2> go
xp_cmdshell







-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
---------------------------------
rem errorlog:
C:\sybase\ase125x\ASE-12_5\install\backup.l

og






C:\sybase\ase125x\ASE-12_5\bin\bcksrvr.exe -SSYB_BACKUP
-eC:\sybase\ase125x\ASE

-12_5\install\backup.log -IC:\sybase\ase125x\ini\sql.ini
-MC:\sybase\as

e125x\ASE-12_5\bin\sybmbuf.exe -Lenglish -Jcp850





(2 rows affected)
Jay

>select @@errorlog
>
>will give us ASE server error log file location. Is there
>any way to get backup server error log file location.


sri Posted on 2009-06-02 08:46:59.0Z
Sender: 174.4a24e3b6.1804289383@sybase.com
From: sri
Newsgroups: sybase.public.ase.general
Subject: Re: How to get backup server error log file location
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a24e703.1ef.1681692777@sybase.com>
References: <4a240ca2.8273757@forums.sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Jun 2009 01:46:59 -0700
X-Trace: forums-1-dub 1243932419 10.22.241.41 (2 Jun 2009 01:46:59 -0700)
X-Original-Trace: 2 Jun 2009 01:46:59 -0700, 10.22.241.41
Lines: 66
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27807
Article PK: 77058

Right Jay, I want to do this from an ASE command.

thanks,
sri

> On 1 Jun 2009 00:27:33 -0700, sri wrote:
>
> I am guessing that you want to do this from an ASE
> command. You possibly could do something with xp_cmdshell
> if you know some things.
>
> e.g. (or maybe a "ps" command if the backup server is
> running from xp_cmdshell).
>
> 1> xp_cmdshell "grep log RUN_SYB_BACKUP.bat"
> 2> go
> xp_cmdshell
>
>
>
>
>
>
>
> ----------------------------------------------------------
> ---------------------
> ----------------------------------------------------------
> ----------------------
> ----------------------------------------------------------
> ----------------------
> ----------------------------------------------------------
> ----------------------
> ----------------------------------------------------------
> ----------------------
> ----------------------------------------------------------
> ---------------------- ---------------------------------
> rem errorlog:
> C:\sybase\ase125x\ASE-12_5\install\backup.l
>
> og
>
>
>
>
>
>
> C:\sybase\ase125x\ASE-12_5\bin\bcksrvr.exe -SSYB_BACKUP
> -eC:\sybase\ase125x\ASE
>
> -12_5\install\backup.log
> -IC:\sybase\ase125x\ini\sql.ini -MC:\sybase\as
>
> e125x\ASE-12_5\bin\sybmbuf.exe -Lenglish -Jcp850
>
>
>
>
>
> (2 rows affected)
> Jay
>
> >select @@errorlog
> >
> >will give us ASE server error log file location. Is there
> >any way to get backup server error log file location.
>