SEO

#1 (**permalink**) 04-08-2008, 02:50 PM

Hi All,

I'm new to Sybase, Recently i got sybase database dump files from my
client.
Which are all together 800MB files. If i try to restore them in my
local sybase which is on Win2K, It keeps on loading for 2 days and
atlast i stopped it thinking there may be some problem.

This is actually what i have given the command..

load database <db_name> from dump_db
stripe on stripe_1_dump_db
stripe on stripe_2_dump_db
stripe on stripe_3_dump_db
stripe on stripe_4_dump_db
stripe on stripe_5_dump_db
go

Can anyone tell me, what is happening and why it taking too long?
or is there any i have to do?

Thanks In Advance,
Praveen

#2 (**permalink**) 04-08-2008, 02:50 PM

Praveen wrote:

> I'm new to Sybase, Recently i got sybase database dump files from my
> client.
> Which are all together 800MB files. If i try to restore them in my
> local sybase which is on Win2K, It keeps on loading for 2 days and
> atlast i stopped it thinking there may be some problem.
>
> This is actually what i have given the command..
>
> load database <db_name> from dump_db
> stripe on stripe_1_dump_db
> stripe on stripe_2_dump_db
> stripe on stripe_3_dump_db
> stripe on stripe_4_dump_db
> stripe on stripe_5_dump_db
> go
>
> Can anyone tell me, what is happening and why it taking too long?
> or is there any i have to do?

You'd need to determine a few things first. What version of
ASE and platform is the dump from? Your system and version
may not be compatible. What was the layout of the original
database? How was the dump made? Was it striped? Are you
able to do a load with the "list_only" or "header_only"
options and get anything useful?

-am © 2003

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Sybase Doubt very URGENT!!!!