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.

Date of backup

3 posts in General Discussion Last posting was on 2010-05-10 08:12:20.0Z
RGS Posted on 2010-05-06 13:58:01.0Z
Sender: 5dd0.4be2c95a.1804289383@sybase.com
From: RGS
Newsgroups: sybase.public.ase.general
Subject: Date of backup
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4be2cae9.5e17.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 May 2010 06:58:01 -0700
X-Trace: forums-1-dub 1273154281 10.22.241.41 (6 May 2010 06:58:01 -0700)
X-Original-Trace: 6 May 2010 06:58:01 -0700, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29178
Article PK: 78415

Frecuently, I make a DUMP of a DATABASE from ASE1 and later
make a LOAD of thar DATABASE on ASE2

Exists any way for know the date when I made the LOAD in
ASE2? Any global variable or table system?

Thanks!!!


ET Posted on 2010-05-06 21:16:50.0Z
From: ET <dbccjob@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Date of backup
References: <4be2cae9.5e17.1681692777@sybase.com>
In-Reply-To: <4be2cae9.5e17.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4be331c2$1@forums-1-dub>
Date: 6 May 2010 14:16:50 -0700
X-Trace: forums-1-dub 1273180610 10.22.241.152 (6 May 2010 14:16:50 -0700)
X-Original-Trace: 6 May 2010 14:16:50 -0700, vip152.sybase.com
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29179
Article PK: 78416

Le 06/05/2010 15:58, RGS a écrit :

> Frecuently, I make a DUMP of a DATABASE from ASE1 and later
> make a LOAD of thar DATABASE on ASE2
>
> Exists any way for know the date when I made the LOAD in
> ASE2? Any global variable or table system?
>
> Thanks!!!

Except in the backup server log file, I do not know.


species8472 Posted on 2010-05-10 08:12:20.0Z
From: Species8472 <species8472@ergens.op.het.net>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Date of backup
References: <4be2cae9.5e17.1681692777@sybase.com>
In-Reply-To: <4be2cae9.5e17.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4be7bfe4$1@forums-1-dub>
Date: 10 May 2010 01:12:20 -0700
X-Trace: forums-1-dub 1273479140 10.22.241.152 (10 May 2010 01:12:20 -0700)
X-Original-Trace: 10 May 2010 01:12:20 -0700, vip152.sybase.com
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29182
Article PK: 78420


On 6/5/10 15:58 , RGS wrote:
> Frecuently, I make a DUMP of a DATABASE from ASE1 and later
> make a LOAD of thar DATABASE on ASE2
>
> Exists any way for know the date when I made the LOAD in
> ASE2? Any global variable or table system?
>
> Thanks!!!

It doesn't

I maintain a small table in every db, which I update in my dump scripts,
so I can query it after a restore

Like this below

what start finish
---------- ------------------- -------------------
db May 10 2010 1:15AM May 10 2010 2:13AM
tran May 10 2010 10:00AM May 10 2010 10:00AM