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.

Scheduled Backup.

6 posts in Backup and Recovery Last posting was on 2010-03-15 22:41:34.0Z
Sabu Posted on 2010-03-12 05:46:45.0Z
Sender: 75dc.4b99d33d.1804289383@sybase.com
From: Sabu
Newsgroups: sybase.public.ase.backup+recovery
Subject: Scheduled Backup.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b99d545.7602.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Mar 2010 21:46:45 -0800
X-Trace: forums-1-dub 1268372805 10.22.241.41 (11 Mar 2010 21:46:45 -0800)
X-Original-Trace: 11 Mar 2010 21:46:45 -0800, 10.22.241.41
Lines: 3
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4100
Article PK: 48187

I am using Sybase Adaptive Server Enterprise (ASE) 12.5. How
can I have a scheduled backup system with this server? I
could not find any facility in Sybase Central.


Chris N. Brown Posted on 2010-03-12 16:47:48.0Z
Content-Type: text/plain; charset="ISO-8859-1"
From: "Chris N. Brown" <cbrown2@sybase.com>
Organization: Sybase, Inc.
User-Agent: KNode/4.4.1
Content-Transfer-Encoding: 7Bit
Subject: Re: Scheduled Backup.
Newsgroups: sybase.public.ase.backup+recovery
References: <4b99d545.7602.1681692777@sybase.com>
Followup-To: sybase.public.ase.backup+recovery
Lines: 14
MIME-Version: 1.0
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b9a7034@forums-1-dub>
Date: 12 Mar 2010 08:47:48 -0800
X-Trace: forums-1-dub 1268412468 10.22.241.152 (12 Mar 2010 08:47:48 -0800)
X-Original-Trace: 12 Mar 2010 08:47:48 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4101
Article PK: 48186

Depending on which version of 12.5 you are using, you could use the job
scheduler to do this. Once installed (and running) you can manage backups
(and other scheduled jobs) from within Sybase Central.

Hope this helps,
Chris

wrote:

> I am using Sybase Adaptive Server Enterprise (ASE) 12.5. How
> can I have a scheduled backup system with this server? I
> could not find any facility in Sybase Central.


Sabu Posted on 2010-03-13 04:42:35.0Z
Sender: 248a.4b9b1636.1804289383@sybase.com
From: Sabu
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: Scheduled Backup.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b9b17bb.24c0.1681692777@sybase.com>
References: <4b9a7034@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Mar 2010 20:42:35 -0800
X-Trace: forums-1-dub 1268455355 10.22.241.41 (12 Mar 2010 20:42:35 -0800)
X-Original-Trace: 12 Mar 2010 20:42:35 -0800, 10.22.241.41
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4108
Article PK: 48194

Hi Chris,

Thanks for the response. I am using the 12.5
version and not 12.5.x, so where do I get the job scheduler
for
12.5 so that I can install it and use it from Sybase Central
to
manage backups?

Sabu

> Depending on which version of 12.5 you are using, you
> could use the job scheduler to do this. Once installed
> (and running) you can manage backups (and other scheduled
> jobs) from within Sybase Central.
>
> Hope this helps,
> Chris
>
>
>
> wrote:
>
> > I am using Sybase Adaptive Server Enterprise (ASE) 12.5.
> > How can I have a scheduled backup system with this
> > server? I could not find any facility in Sybase Central.
>


Chris N. Brown Posted on 2010-03-15 22:09:48.0Z
Content-Type: text/plain; charset="ISO-8859-1"
From: "Chris N. Brown" <cbrown2@sybase.com>
Organization: Sybase, Inc.
User-Agent: KNode/4.4.1
Content-Transfer-Encoding: 7Bit
Subject: Re: Scheduled Backup.
Newsgroups: sybase.public.ase.backup+recovery
References: <4b9a7034@forums-1-dub> <4b9b17bb.24c0.1681692777@sybase.com>
Followup-To: sybase.public.ase.backup+recovery
Lines: 45
MIME-Version: 1.0
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b9eb02c$1@forums-1-dub>
Date: 15 Mar 2010 14:09:48 -0800
X-Trace: forums-1-dub 1268690988 10.22.241.152 (15 Mar 2010 14:09:48 -0800)
X-Original-Trace: 15 Mar 2010 14:09:48 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4109
Article PK: 48195

Ahhh ... yeah the Job Scheduler was introduced in 12.5.1. I did a quick
ping to engineering and you can't have 12.5 be the job scheduler server, but
it's possible to have 12.5 be the target of jobs.

So, what I would suggest is d/l or obtain the latest version of Sybase
Central, and a version of ASE later than 12.5.1. Run through the installer,
and install the job scheduler piece. After that, check out the docs at:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20001_1251/html/jsusers/BABEIJDI.htm

HTH,
Chris

wrote:

> Hi Chris,
>
> Thanks for the response. I am using the 12.5
> version and not 12.5.x, so where do I get the job scheduler
> for
> 12.5 so that I can install it and use it from Sybase Central
> to
> manage backups?
>
> Sabu
>
>> Depending on which version of 12.5 you are using, you
>> could use the job scheduler to do this. Once installed
>> (and running) you can manage backups (and other scheduled
>> jobs) from within Sybase Central.
>>
>> Hope this helps,
>> Chris
>>
>>
>>
>> wrote:
>>
>> > I am using Sybase Adaptive Server Enterprise (ASE) 12.5.
>> > How can I have a scheduled backup system with this
>> > server? I could not find any facility in Sybase Central.
>>


"Mark A. Parsons" <iron_horse Posted on 2010-03-15 22:37:51.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: Scheduled Backup.
References: <4b99d545.7602.1681692777@sybase.com>
In-Reply-To: <4b99d545.7602.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 100313-1, 03/13/2010), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b9eb6bf$1@forums-1-dub>
Date: 15 Mar 2010 14:37:51 -0800
X-Trace: forums-1-dub 1268692671 10.22.241.152 (15 Mar 2010 14:37:51 -0800)
X-Original-Trace: 15 Mar 2010 14:37:51 -0800, vip152.sybase.com
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4110
Article PK: 48196

What OS are you running your ASE on?

If Unix or Linux, any reason why you don't use cron and a shell script? IMO, cron's easier to use than ASE's Job Scheduler.

If you're on a MSWindows platform you could also try the builtin scheduler and a batch file. [Haven't done much with
MSWindows schedulers but I recall it wasn't too much more complicated than cron, ymmv.]

Sabu wrote:
> I am using Sybase Adaptive Server Enterprise (ASE) 12.5. How
> can I have a scheduled backup system with this server? I
> could not find any facility in Sybase Central.


"Mark A. Parsons" <iron_horse Posted on 2010-03-15 22:41:34.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: Scheduled Backup.
References: <4b99d545.7602.1681692777@sybase.com> <4b9eb6bf$1@forums-1-dub>
In-Reply-To: <4b9eb6bf$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 100313-1, 03/13/2010), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b9eb79e@forums-1-dub>
Date: 15 Mar 2010 14:41:34 -0800
X-Trace: forums-1-dub 1268692894 10.22.241.152 (15 Mar 2010 14:41:34 -0800)
X-Original-Trace: 15 Mar 2010 14:41:34 -0800, vip152.sybase.com
Lines: 19
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4111
Article PK: 48197

... and with a stored proc and a couple thresholds (on the tran log) you can automate the dumping of your transaction
log. Can come in handy for those times where you may have a [large] spike in transactional activity between regularly
scheduled log dumps.

Mark A. Parsons wrote:
> What OS are you running your ASE on?
>
> If Unix or Linux, any reason why you don't use cron and a shell script?
> IMO, cron's easier to use than ASE's Job Scheduler.
>
> If you're on a MSWindows platform you could also try the builtin
> scheduler and a batch file. [Haven't done much with MSWindows
> schedulers but I recall it wasn't too much more complicated than cron,
> ymmv.]
>
> Sabu wrote:
>> I am using Sybase Adaptive Server Enterprise (ASE) 12.5. How
>> can I have a scheduled backup system with this server? I
>> could not find any facility in Sybase Central.