Summary: SYBASE backup question

From: judyh@nikko.com
Date: Mon Aug 05 1996 - 09:09:55 CDT


Thanks a lot to:
Development <devjrt@sonic.urich.edu>
mike@trdlnk.com (Michael Sullivan)
jrussell@gate.comdata.com (John Russell)
keith@oz.health.state.mn.us (Keith Willenson)
Marina.Daniels@ccd.tas.gov.au (Marina Daniels)
Bob Fulwiler <bobf@psa.pencom.com>
george@dbms.com (George L Roman)
scott@msi-uk.com (Scott McDonald)
"Marks, Evan R" <markser@aetna.com>
"Ing. Carlos Ramon Guevara" <cguevara@ns.sinfo.net>
skip@hisnj.com (Paul Seelaus)

The answer is:

1. On the remote host (which has a tape drive), export a file system, eg. /remotedump;
2. On the local host (which has sybase to be dumped), mount that /remotedump;
3. On the local host, make /remotedump/dump.dat as the "disk" type dumpdevice;
4. Do the dump to /remotedump/dump.dat on the local host;
5. On the remote host, use "tar" to copy /remotedump/dump.dat to a tape.

It works, but, If I want to do a LOAD, I have to un-tar that tape to a file, and then load that file using sybase's command.

I cann't load that tape directly from the tape drive since the blocksize of the tape image is not recognized by sybase.

I cann't find the blocksize of /remotedump/dump.dat when I copy it to the tape, so I use tar, if so, maybe I can use dd. Can you tell me how to find the blocksize of /remotedump/dump.dat?

And, if I use a tape drive attached to sybase locally, I can dump both database and tran to the same tape.

But, I cannot dump both database and tran to the same filename (eg. /remotedump/dump.dat). Is there a way to do so?

thanks a lot for you patient.

-Judy

-------------------
My question was:

I'am new to SYBASE admin. and I have a question. I've searched SYBOOK without help.

We have a SUNOS with SYBASE installed and our database is dumped everyday to it's local tape drive.

Is it possible to remote dump our database to a Solaris machine which is not running SYBASE?

If so, how?

I tried: dump database db_name to "/dev/rst1" at host_name

And I added "host_name" to sysservers table using "sp_addserver". Didn't work.

It seems that I have to install another SYBASE on my "host_name".

Thanks a lot!

-Judy

----- End Included Message -----



This archive was generated by hypermail 2.1.2 : Fri Sep 28 2001 - 23:11:06 CDT