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.

Sybase DRP

5 posts in Backup and Recovery Last posting was on 2011-10-03 17:49:35.0Z
chris Posted on 2011-09-29 20:26:17.0Z
Sender: af9.4e81d5fb.1804289383@sybase.com
From: Chris
Newsgroups: sybase.public.ase.backup+recovery
Subject: Sybase DRP
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e84d469.5c9b.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Sep 2011 13:26:17 -0700
X-Trace: forums-1-dub 1317327977 10.22.241.41 (29 Sep 2011 13:26:17 -0700)
X-Original-Trace: 29 Sep 2011 13:26:17 -0700, 10.22.241.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4170
Article PK: 48255

We have a nightly batch process written years ago that does
a lot of minimally logged transactions (select into/bulk
copy, drop triggers, drop indexes, truncate tables). Making
changes to the jobs could be intense. Is there a way we can
get the data on to a disaster recovery site within a 15
minute window and ensure all data is there?

For example, using sybase replication or some form of
operating system replication/mirroring (at the os, file
system or disk level)??

Any expertise/experience out there that have been successful
with something like this??

Thanks in advance,


Michael Peppler [Team Sybase] Posted on 2011-10-03 04:54:24.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: Sybase DRP
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2011.10.03.04.54.24.602701@peppler.org>
Newsgroups: sybase.public.ase.backup+recovery
References: <4e84d469.5c9b.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 2 Oct 2011 21:54:24 -0700
X-Trace: forums-1-dub 1317617664 10.22.241.152 (2 Oct 2011 21:54:24 -0700)
X-Original-Trace: 2 Oct 2011 21:54:24 -0700, vip152.sybase.com
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4171
Article PK: 48256


On Thu, 29 Sep 2011 13:26:17 -0700, Chris wrote:

> We have a nightly batch process written years ago that does a lot of
> minimally logged transactions (select into/bulk copy, drop triggers, drop
> indexes, truncate tables). Making changes to the jobs could be intense.
> Is there a way we can get the data on to a disaster recovery site within a
> 15 minute window and ensure all data is there?
>
> For example, using sybase replication or some form of operating system
> replication/mirroring (at the os, file system or disk level)??

Sybase Replication, or OS-level replication (SRDF in a SAN, for example)
works quite well for this purpose. For Sybase replication the latency can
be relatively high if you have very large transactions, but this can be
mittigated with large replication queues.

Michael