[comp.databases] duplicating master database between 2 separate machines ??

eric@picard.sbi.com (Eric Ho) (01/08/91)

Is there a way to duplicate the master database from one machine to another ?
The machine I want to duplicate to is a brand new machine with a fresh copy
Sybase installed.

I dumped the master database (and its transaction log) from the old machine
into 2 Unix files (one for the database and one for the trans. log), moved the
files over to the new machine, bring down the dataserver daemon on the new
machine into single-user mode (via the -m flag) and then tried to reload the
master database from the Unix file.

Then strange thing is that after the reload is done, I was immedately thrown
out of isql and that the dataserver daemon die.  And when I restart the
dataserver again (in single-user mode, via -m), I got all kinds of server &
kernel barfs.  THe server barfs mainly complain about sysindexes for clustered
index.  And the kernel barfs said :-

	kernel: curcmd = 0, program = 
	kernel: Bus error - current process infected
	kernel: pc: 0x147b48
	... more pc: lines ...
	...
	kernel: end of stack trace, spid 1, kpid 4, suid 1

However, the dataserver daemon still runs depsite of these kernel barfs.

Is this a bug of Sybase or I've done something wrong ?
--

==========================================
+ Eric Ho                          Email: eric@sbi.com
+ Salomon Brothers, Inc.  [SISS]   Phone: (212) 855-3003
==========================================