If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Sybase > problem load database from dump

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-29-11, 06:40
eskuai eskuai is offline
Registered User
 
Join Date: Mar 2011
Posts: 2
problem load database from dump

Hello,

I am trying to port from solaris to linux a database . All database are 12.0.3 , 4k size page ... same database size, etc ...

I've done the "dump", following steps from sybase, single mode user, flush, dump trans, etc, and i've tried 4 times ... the same problem always:

The process starts ok, ... a long time ... 100 gb database ... and at least

Cross-platform conversion for database TEST44: 17114604 pages completed.
Cross-platform conversion for database TEST44: 17366289 pages completed.
Cross-platform conversion for database TEST44: 24916839 pages completed.
Cross-platform conversion for database TEST44: 25064484 pages completed.
Completed cross-platform conversion for user objects.
Started cross-platform conversion for log records.
Msg 3151, Level 16, State 2:
Server 'sdmxg101', Line 1:
Adaptive Server cannot load this database because the database that was dumped was not quiescent when the dump was performed. Run sp_flushstats before DUMP DATABASE and ensure that the database is not updated during the dump.
1> 2> 3>

I've read about it "after googling" , but no solutions ...

how to fix it ? .. ideas ... if it is a trans log ... i dont need it .. can i remove it ?

please help,

thank you
Reply With Quote
  #2 (permalink)  
Old 04-04-11, 09:24
ramshree ramshree is offline
Registered User
 
Join Date: Nov 2002
Posts: 90
its failing at log but though you dont need it you can not ignore it.

If you are running sp_flushstats before dump on source server and still having issue couple of things you can try as:

set trunc log on check pt on DB, dump database still see issue then you can try bounce the source server once.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On