Discussion:
fatal error when loading db
(too old to reply)
andkylee
2009-07-01 08:56:26 UTC
Permalink
Raw Message
dear all,

here we had a fatal error with our sybase database.i loaded the database
"escourt5" from the dump file of database "courtdb" . we had the dump file
of one year ago .how can i do ?
sybase 12.5.0.3 on windows 2003 server.
sybase tech telled me that there is no way as sybase load procedure
overwritten the database pages.

the sybase data files are placed at an array,can we recover the device
files from a preview time?
any help?
Mark A. Parsons
2009-07-01 14:07:34 UTC
Permalink
Raw Message
I'm a little confused by what you're saying so I'm going to make some assumptions:

- the escourt5 database had some fatal errors which caused it to become corrupted

- when you tried to load an old dump of the escourt5 database you accidentally loaded the dump file into the courtdb
database (ie, you loaded the dump into the wrong database)

- you now have 2 bad databases ... a corrupted escourt5 database ... and the courtdb which has been overwritten with an
old copy of the escourt5 database

----------------

If my assumptions are incorrect then you'll need to take some time to provide more details describing your situation.

----------------

re: escourt5 database:

You can try loading the old database dump into the escourt5 database; whether this newly loaded escourt5 database will
be of any use depends on a couple issues ... was the database 'clean' (ie, uncorrupted) when it was dumped ... can you
live with the 'old' data?

----------------

re: courtdb database:

One way you could get back (some of) your data would be to load the database from a backup file(s) (you would lose any
data that had changed since the last backup and the point at which you overwrote the courtdb database with the escourt5
dump file).

Another option ... if your system adminitrator makes regular backups of your sybase device files then you *might* be
able to recover your courtdb database back to the point of the last time the administrator backed up your sybase device
files (there is a chance this may not work if there was any activity in the database at the time the devices were being
copied/backed-up).

Another option ... rebuild the courtdb database from scratch (eg, create table, bcp data into tables, etc). This
assumes that you can reconstitute the data from other sources (eg, flat files, data load/feed processes, copies of data
pulled from other databases).

Ultimately it comes down to a question of whether or not you have any sort of backup for the data that used to reside in
the courtdb database.
Post by andkylee
dear all,
here we had a fatal error with our sybase database.i loaded the database
"escourt5" from the dump file of database "courtdb" . we had the dump file
of one year ago .how can i do ?
sybase 12.5.0.3 on windows 2003 server.
sybase tech telled me that there is no way as sybase load procedure
overwritten the database pages.
the sybase data files are placed at an array,can we recover the device
files from a preview time?
any help?
Loading...