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.

Archiving an ASE server , HOW TO...

3 posts in Windows NT Last posting was on 2001-04-12 15:43:16.0Z
Wim Mintiens Posted on 2001-04-11 08:14:55.0Z
From: "Wim Mintiens" <wim.mintiens@prodata-systems.be>
Subject: Archiving an ASE server , HOW TO...
Date: Wed, 11 Apr 2001 10:14:55 +0200
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <Ull9xImwAHA.157@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: uu194-7-94-30.unknown.uunet.be 194.7.94.30
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:963
Article PK: 1087570

My customer wants periodicaly to archive some data from his ASE server

does anyone know of a procedure or product that can do this

ARCHIVE (for my customer) means copying data to an secundary medium,clearing
it
from primary medium( disk) but still be able to retrieve data afterwards, to
nessecary on-line ....after restoring or whatever...

regards,
WIM


Jim Egan Posted on 2001-04-12 15:43:16.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: Archiving an ASE server , HOW TO...
Date: Thu, 12 Apr 2001 09:43:16 -0600
Message-ID: <MPG.153f7afe2f1a1fb298b281@forums.sybase.com>
References: <Ull9xImwAHA.157@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.nt
Lines: 13
NNTP-Posting-Host: jpe650.sybase.com 157.133.56.43
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:957
Article PK: 1087564

You could set up an ASIQ database server to function as the archive. Dump data to it when
it is ready to get flushed out of the main database. Then set up CIS to talk from the main
database server to the data warehouse you've created in ASIQ. This way you have the data
on-line and finding what you need can be incredibly fast.
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com


Manish Patel Posted on 2001-04-12 12:42:07.0Z
From: "Manish Patel" <manishbpatel@hotmail.com>
References: <Ull9xImwAHA.157@forums.sybase.com>
Subject: Re: Archiving an ASE server , HOW TO...
Date: Thu, 12 Apr 2001 08:42:07 -0400
Lines: 48
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <ZkdTwC1wAHA.191@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: gfd.com 208.249.143.82
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:959
Article PK: 1087566

One of the solution :
1) Create an database that will hold the archive data (may be on the same
server)
2) Put the database in seprate device/disk then the primary database
3) Create stored procedures that will insert data into secondary(archive)
database from primary database
4) Delete the archived data from the primary database
5) Schedule the stored procedures to run periodically (you can use any 3rd
party tools or if you are on unix you may use cron jobs)

The Advantage of having the archive(secondary database) on the same server :
1) You won't need to send data across servers(if the secondary database is
on same server).
2) Customers can retrieve data from the same server after archiving the
data.
3) One less server to maintain

Disadvantages :
1) Increate workload on the server that holds both primary & secondary
database
2) More disk space required.
3) Recovery might be long if the secondary (archive) database is big.

I hope this helps with your problem

Manish

Wim Mintiens wrote in message ...
>My customer wants periodicaly to archive some data from his ASE server
>
>does anyone know of a procedure or product that can do this
>
>ARCHIVE (for my customer) means copying data to an secundary
medium,clearing
>it
>from primary medium( disk) but still be able to retrieve data afterwards,
to
>nessecary on-line ....after restoring or whatever...
>
>regards,
>WIM
>
>
>
>