views:

147

answers:

1

hi,

I am working on load database dumps to new ase server. but when I try to load 15gb and 32gb dumps to database, I get below error. When I load 2gb dump to db, everything fine. I search on net and they advice to get db dump with sp_flushstats in single user more but I have no chance to get new dumps.

isql

1> load database db1

2> from 'compress::/home/aykut/db1_1'

3> stripe on 'compress::/home/aykut/db1_2'

4> go

.

.

.

Backup Server: 4.58.1.1: Database db1: 232722 kilobytes LOADED.

Backup Server: 4.58.1.1: Database db1: 405786 kilobytes LOADED.

.

.

.

Cross-platform conversion for database db1: 7593874 pages completed.

Cross-platform conversion for database db1: 7672159 pages completed.

Cross-platform conversion for database db1: 7750444 pages completed.

Cross-platform conversion for database db1: 7796344 pages completed.

Completed cross-platform conversion for user objects.

Started cross-platform conversion for log records.

Msg 3151, Level 16, State 2: Server 'TestServer', 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.

well, these dumps has taken from ase 12.5 instance located on solaris sparc and I try to load these dumps to ase 12.5 instance located on linux x86. is that cause an issue? or can this error be related with ase developer edition's database size limit?

thx and regards.

+2  A: 

Read official docs about crossplatform dump.

PS: You must redumped database. Before dump you must run DB in singlemod and call sp_flushstats. After database loaded - dbcc reindex, update statistics, sp_recompile.

http://www.sybase.com/detail?id=1033627

slav0nic
It also helps to dump the transaction log before running sp_flushstats
Todd Pierce