Syntel-Sybase Developers:Contract in Mumbai 5pos looking out for Sybase Developer 1.) Have good Experience in Sybase Development, Sybase 12.0,...

rathode

04-23-2008 12:46 AM
rathode

Hi all, I work with ASE Server 15.0.2 and I have a problem when I load a DUMP. I have two physical devices, one for data (mydb_data.dat of 10Gb) and...

Mario Ascione

04-14-2008 10:20 AM
Bret Halford

I am using the sybase job scheduler to run my database and log dumps. The output is generally too long for the log file viewer in sybase central as...

christopher avery

02-29-2008 11:20 AM
christopher avery

Dear Newsgroup User, Sybase is very interested in obtaining feedback regarding usage of the Sybase newsgroups. We would appreciate your taking a few...

Audrey Irwin

02-20-2008 09:37 AM
Audrey Irwin

I am having trouble to bring up our ASE12.5.2 server. I am getting the log message as below. It stayed at 'Started REDO pass..' for over an hour...

Audrey Won

02-04-2008 10:37 AM
Bret Halford

Hi Guys, I'm be tired of manually load my database. So I have to code a script which does this. There is one point I need help: In order to load a...

Heinz Müller

02-02-2008 05:09 AM
Heinz Müller

ASE 15.0.2 on Linux. For years we've been dumping directly to tape. We're now changing to disk dumps, so it'll complete faster and we'll have handy...

Larry Coon

01-21-2008 10:15 AM
Eugene Korolkov

Hi, I am running bcp command on SQL 2000. it shows message "1000 rows successfully bulk-copied to host-file" for every 1000 records processed. is...

shantanua@gmail.com

01-17-2008 07:20 AM
Manish Negandhi

Hi Folks, I've been happily restoring copies of dump files from one box onto another for several years. But, during a recent upgrade to the...

JMCraig

12-24-2007 02:05 PM
JMCraig

How do you recover a database when the file system where the sybase devices (flat files) resided were deleted? The ASE was up and running and I tried...

D Brown

12-23-2007 05:23 AM
Derek Asirvadem

We have a large application with the data split over multiple subject area databases on the same ASE 15 server. Analysts perform updates...

Gerald Whyte

12-14-2007 09:45 AM
Rob Verschoor

Does anyone know Sybase backup server archive API? Any documents would be appreciated.

askoliver@gmail.com

12-07-2007 08:05 AM
SybaseNeal

Hi DBAs, How Do I recover a single 'user database' from device files? Example situation: - The "DESENV" database was droped and its device files...

Jorge L. Silva

12-05-2007 01:06 PM
Jorge L. Silva

We're reviewing our disaster recovery procedures now that we've upgraded to 15.0.2 (from 12.5.0.3). In fact, we're getting the opportunity to test...

Richard

11-30-2007 06:05 AM
A. M.

Hi, I'm using ddlgen in AIX to generate the DDL for a complete DB. ASE 12.5.3 the DB is 2GB. I am getting the following message only on DB's larger...

rick_806

11-15-2007 04:25 PM
rick_806

Hello, We are using ASE 12.5.4. I came accross some articles from Robert Verschoor that sybase started including sybedit tool in ASE 12.0. However, I...

jai

11-14-2007 08:38 AM
Jason L. Froebe [TeamSybase]

we are trying to load some dump in Devlopment server from Production Server we are getting this error Can anyone explain, how to solve this..?? ...

s.joydeep

11-13-2007 07:59 AM
Michael Heaney

Hi, I would like to create a dev database identical to my production database on ASE 12.5.4. I have a dump from the production database done with...

cv@lecentre.net

11-09-2007 06:21 AM
Mark A. Parsons

Hello, I have a Sybase 12 DB that i want to move to a development machine, which runs ASE 15. What is the proper procedure to do this? In SQL...

fiaola

11-04-2007 12:48 AM
fiaola

Hi! I know Sybase supports cross-platform db backup/restore. I could successfully restore a HPUX db dump to a Windows-based Sybase. However, when I...

Peter Lo

10-26-2007 04:05 AM
Manish Negandhi

Hello, I'm in trouble :-). We had disk problems, and I have to recover some databases. When I start the server, it seems that the recovery stops at...

Luc Van der Veurst

10-25-2007 12:25 PM
Luc Van der Veurst

Like many of you I've dragged my feet with the new-ish compression syntax. As the "with compression = X" syntax is required (if you're going to...

Jason L. Froebe [TeamSybase]

10-12-2007 06:09 PM
A. M.

Guys, FYI - Right after 15.0.2 was released I did a test of the Archive Database feature. I found that the "number of locks" parameter must be set...

Cory

10-11-2007 07:16 AM
Cory

ENJOYING WEBSITES at fit4money (AT) gmx (DOT) net Hello friends, I got good Websites from fit4money (AT) gmx (DOT) net For Interest send an Mail...

ENJOYING WEBSITES at fit4money@gmx.net

10-10-2007 11:44 AM
ENJOYING WEBSITES at fit4money@gmx.net

Hi, Can I take a database dump from ASE15.0.2 and load it into ASE 12.5.4 Thanks Germano

Germano Silva

10-09-2007 09:54 AM
Manish Negandhi

We've been performance testing. The database dumps of db1 (87 GB data) take 16 minutes at 5.4 GB/min. The database dumps of db2 (16 GB data) take...

AW

09-26-2007 04:28 AM
A. M.

I'm having some performance problems with loading multiple dumps from tape. The dumps are large and we have 28 databases on tape. Towards the end of...

deanjones7@gmail.com

09-19-2007 11:24 AM
bret@sybase.com

How do we password protect our backup server for ASE15.0.2? Our security team was able to scan the port for which the backup server is listening. I...

D Brown

09-19-2007 05:50 AM
Rob Verschoor

Guys, ASE Version 12.5.3esd#5 We switched from compress:: to with compression=1. This is to disk files with or without stripes & passwords. We did...

Cory

09-14-2007 01:17 AM
deanjones7@gmail.com

The 101 ROMANTIC SECRETS and TECHNICS This SECRETS and TECHNICS are right for you if: 1. How to try to get a person you want, 2. To make your...

The 101 ROMANTIC SECRETS

09-07-2007 11:18 AM
The 101 ROMANTIC SECRETS

Is there a limit on how big a file can be when bcping out data? I'm trying to bcp out a large file and it keeps failing. I get to 12356000 rows...

Eric

08-31-2007 08:34 AM
Cory

HI! This morning, I restarted my Sybase server (running on a Windows machine). I found that a database was under recovery. But, the recovery has...

Peter Lo

08-29-2007 09:36 PM
Mark K

Hello, Getting below error while doing dumpdatabase to tape through Veritas: ************************************************************* Aug 23...

Ambar

08-28-2007 02:53 AM
Ambar

Hi Guys, We have been having a wierd problem since the last few months. We sometimes get an insufficient system resources issue while performing a...

Elangovan Raman

08-21-2007 10:33 AM
Elangovan Raman

Hi, I have a production database that been allocated with 1GB but only 100MB of it is used. I would like to dump that database from the production...

Huynh

08-08-2007 06:31 PM
Mark A. Parsons

I encountered this errors while loading production database. Sybase 11.9.2.1 on HP-UX Jul 25 11:47:20 2007: Backup Server: 3.29.2.1: No...

Ohi Akhibi

08-07-2007 11:38 AM
Ohi Akhibi

Is it possible to use the "compress::3:: ..." syntax with a tape device and backup server? I've been trying and it doesn't seem to want to work. And,...

deanjones7@gmail.com

07-25-2007 07:13 PM
deanjones7@gmail.com

Sybase Gurus, Could one of you give me the command to BCP out a complete Sybase DB into a flat file. The DB size is just 1GB+. Thanks in...

sqlsrini@gmail.com

07-24-2007 05:22 AM
sqlsrini@gmail.com

Hi all, I faced problem that sometimes when I backup database by dump database It appears to be hung. and the dump file was not succeed. But sometime...

somchai

07-13-2007 03:58 AM
Emmanuel Torre

I must first admit that I am a complete nube when it comes to Sybase and I've just had a very vexing problem dropped in my lap that I hope someone...

Ken Ross

07-09-2007 10:32 AM
Ken Ross

System: ASE 11.9.2.3 on Debian Linux (dual Xeon 2.8Ghz, 3GB Ram, Scsi Raid 5). Hi, we have a problem with the dump of one big database....

Simone Pirovano

07-04-2007 08:41 AM
Mark A. Parsons

ASE 15 Award Program: We are pleased to announce the ASE 15 Award Program: In Search of Agent 15 What it is: An award program to recognize our...

Amy Randers

06-27-2007 05:43 AM
Amy Randers

Hi all, I would like to run the test for backup/restore sybase database (Sybase ASE 12.5.1 on Solaris 8). as I can successfully to restore the...

STandard

06-23-2007 10:58 AM
Rob Verschoor

I need to unload a sybase ase 12.5 database into a named pipev rather than a file. I heard this was not possible to use named pipes. Anyone have...

Jim Morrissey

06-04-2007 04:34 AM
A. M.

I need to unload 1Tb of data into flat ascii files from ase 12.5 (Solaris 8, E10k), but there is not nearly enough disk space left to do this. I'd...

Jim Morrissey

06-01-2007 03:17 PM
Sherlock, Kevin

Hello Sybase Gurus, I have a problem getting EMC NetWorker Sybase Module working with Sybase ASE 12.5. My set-up/environment. Legato NetWorker...

ksmith169@googlemail.com

05-22-2007 08:05 AM
ksmith169@googlemail.com

Hi everybody, I've setup mirrored disks (on separate physycal devices - for the case of one of devices will go broken) to be safe on power failure. I...

Serge

05-11-2007 09:01 PM
A. M.

Hello guys...years ago i readed some about partial load. I can to get an utility integrate in any version of ASE 12.0.x, however i don't remember...

Josué Alvarado G.

05-06-2007 09:18 AM
Rob Verschoor

I know that sybase dumps were just upward compatible in the past. Has this been changed in ASE 15 ? I mean can I load a dump from ASE 15 to a ASE...

Bernd

04-29-2007 07:33 AM
Rob Verschoor

We are running Adaptive Server Enterprise/12.5.2/EBF 11799/P/Linux Intel/Enterprise Linux/ase1252/1831/32-bit and have been for some time without...

S Rosenblum

04-24-2007 06:13 PM
A. M.