Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Unanswered: 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

  2. #2
    Join Date
    Nov 2002
    Posts
    94
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •