Unable to load Cross platform backup

Discussion:

(too old to reply)

unknown

2009-11-23 12:13:17 UTC

Hello,

I am trying to load a backup taken on IBM PowerPC server running AIX 5.2 and
ASE 15.0.2 to a Sun xVM virtual machine running RHEL 5 (on WinXP) and Sybase
ASE 15.0.3 Developer edition. The load is unsuccessful and here is the whole
message list. The DB load is successful portion goes into the Backup log but
not the messages appearing thereafter. When it is doing Cross platform
conversion of the log it gives an error message that the DB was not
quiesced. Why is that necessary. I did this first time so it said keep the
server in single user, do sp_flushstats so I did that and again took a
backup. But it continues to give this error at the fag end of the load.

The message below are from the screen.

1> create database mydb on mydbdata1=7500, mydblog1=1000, mydbdata2=1000 log
on mydbdata1=1000, mydblog1=2500 with override for load
2> go
CREATE DATABASE: allocating 3840000 logical pages (7500.0 megabytes) on disk
'mydbdata1'.
CREATE DATABASE: allocating 512000 logical pages (1000.0 megabytes) on disk
'mydblog1'.
CREATE DATABASE: allocating 512000 logical pages (1000.0 megabytes) on disk
'mydbdata2'.
CREATE DATABASE: allocating 512000 logical pages (1000.0 megabytes) on disk
'mydbdata1'.
CREATE DATABASE: allocating 1280000 logical pages (2500.0 megabytes) on disk
'mydblog1'.
Caution: You have set up this database to include space on disk 4 for both
data and the transaction log. This can make recovery impossible if that
disk fails.
Caution: You have set up this database to include space on disk 6 for both
data and the transaction log. This can make recovery impossible if that
disk fails.
Processed 2600 allocation unit(s) out of 26000 units (allocation page
665344). 10% completed.
Processed 5200 allocation unit(s) out of 26000 units (allocation page
1330944). 20% completed.
Processed 7800 allocation unit(s) out of 26000 units (allocation page
1996544). 30% completed.
Processed 10400 allocation unit(s) out of 26000 units (allocation page
2662144). 40% completed.
Processed 13000 allocation unit(s) out of 26000 units (allocation page
3327744). 50% completed.
Processed 15600 allocation unit(s) out of 26000 units (allocation page
3993344). 60% completed.
Processed 18200 allocation unit(s) out of 26000 units (allocation page
4658944). 70% completed.
Processed 20800 allocation unit(s) out of 26000 units (allocation page
5324544). 80% completed.
Processed 23400 allocation unit(s) out of 26000 units (allocation page
5990144). 90% completed.
Processed 26000 allocation unit(s) out of 26000 units (allocation page
6655744). 100% completed.
1> select db_name()
2> go

------------------------------------------------------------
master

(1 row affected)
1> load database mydb from 'compress::6::/opt/sybase/mydb201109.dmp'
2> go
Backup Server session id is: 7. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.132.1.1: Attempting to open byte stream device:
'compress::6::/opt/sybase/mydb201109.dmp::00'
Backup Server: 6.28.1.1: Dumpfile name 'mydb0932407B98 ' section number 1
mounted on byte stream 'compress::6::/opt/sybase/mydb201109.dmp::00'
Backup Server: 4.188.1.1: Database mydb: 140636 kilobytes (1%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 276212 kilobytes (2%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 402634 kilobytes (3%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 539874 kilobytes (4%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 669690 kilobytes (5%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 799506 kilobytes (6%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 944744 kilobytes (7%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1074746 kilobytes (8%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1204364 kilobytes (9%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1334366 kilobytes (10%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1478642 kilobytes (11%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1608260 kilobytes (12%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1738262 kilobytes (13%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1867880 kilobytes (14%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1997882 kilobytes (15%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2142158 kilobytes (16%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2271776 kilobytes (17%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2401778 kilobytes (18%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2531396 kilobytes (19%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2675672 kilobytes (20%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2805290 kilobytes (21%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2935292 kilobytes (22%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3064910 kilobytes (23%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3202142 kilobytes (24%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3340526 kilobytes (25%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3461564 kilobytes (26%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3599820 kilobytes (27%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3738204 kilobytes (28%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3876972 kilobytes (29%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3998010 kilobytes (30%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4136394 kilobytes (31%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4274778 kilobytes (32%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4396200 kilobytes (33%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4534584 kilobytes (34%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4672968 kilobytes (35%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4794006 kilobytes (36%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4932328 kilobytes (37%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5071158 kilobytes (38%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5192196 kilobytes (39%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5330580 kilobytes (40%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5468964 kilobytes (41%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5607732 kilobytes (42%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5728770 kilobytes (43%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5867154 kilobytes (44%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6005538 kilobytes (45%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6126960 kilobytes (46%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6265344 kilobytes (47%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6403728 kilobytes (48%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6524766 kilobytes (49%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6663088 kilobytes (50%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6801918 kilobytes (51%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6922956 kilobytes (52%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7061340 kilobytes (53%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7199724 kilobytes (54%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7338492 kilobytes (55%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7459530 kilobytes (56%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7597914 kilobytes (57%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7736298 kilobytes (58%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7857720 kilobytes (59%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7996104 kilobytes (60%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8134488 kilobytes (61%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8253738 kilobytes (62%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8394372 kilobytes (63%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8524188 kilobytes (64%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8654004 kilobytes (65%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8794638 kilobytes (66%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8924454 kilobytes (67%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9054270 kilobytes (68%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9194904 kilobytes (69%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9324720 kilobytes (70%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9454536 kilobytes (71%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9595170 kilobytes (72%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9724986 kilobytes (73%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9854802 kilobytes (74%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9984618 kilobytes (75%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10125252 kilobytes (76%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10255068 kilobytes (77%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10384884 kilobytes (78%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10525518 kilobytes (79%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10655334 kilobytes (80%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10785150 kilobytes (81%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10925784 kilobytes (82%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11055600 kilobytes (83%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11185416 kilobytes (84%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11315232 kilobytes (85%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11455866 kilobytes (86%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11585682 kilobytes (87%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11715498 kilobytes (88%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11856132 kilobytes (89%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11985948 kilobytes (90%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12115764 kilobytes (91%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12256398 kilobytes (92%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12386214 kilobytes (93%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12516030 kilobytes (94%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12656664 kilobytes (95%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12786480 kilobytes (96%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12916296 kilobytes (97%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 13046112 kilobytes (98%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 13186746 kilobytes (99%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 13314002 kilobytes (100%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 13314014 kilobytes (100%) LOADED.
Backup Server: 3.42.1.1: LOAD is complete (database mydb).
Started cross-platform conversion for database mydb.
Started cross-platform conversion for system objects.
Cross-platform conversion for database mydb: 10000 pages completed.
Cross-platform conversion for database mydb: 20000 pages completed.
Cross-platform conversion for database mydb: 26624 pages completed.
Completed cross-platform conversion for system objects.
Started cross-platform conversion for user objects.
Cross-platform conversion for database mydb: 66658 pages completed.
Cross-platform conversion for database mydb: 133460 pages completed.
Cross-platform conversion for database mydb: 200270 pages completed.
Cross-platform conversion for database mydb: 266985 pages completed.
Cross-platform conversion for database mydb: 333787 pages completed.
Cross-platform conversion for database mydb: 400597 pages completed.
Cross-platform conversion for database mydb: 467391 pages completed.
Cross-platform conversion for database mydb: 534193 pages completed.
Cross-platform conversion for database mydb: 601003 pages completed.
Cross-platform conversion for database mydb: 667813 pages completed.
Cross-platform conversion for database mydb: 734623 pages completed.
Cross-platform conversion for database mydb: 801433 pages completed.
Cross-platform conversion for database mydb: 868243 pages completed.
Cross-platform conversion for database mydb: 935053 pages completed.
Cross-platform conversion for database mydb: 1001863 pages completed.
Cross-platform conversion for database mydb: 1068673 pages completed.
Cross-platform conversion for database mydb: 1135483 pages completed.
Cross-platform conversion for database mydb: 1202285 pages completed.
Cross-platform conversion for database mydb: 1269095 pages completed.
Cross-platform conversion for database mydb: 1335905 pages completed.
Cross-platform conversion for database mydb: 1402715 pages completed.
Cross-platform conversion for database mydb: 1469525 pages completed.
Cross-platform conversion for database mydb: 1536335 pages completed.
Cross-platform conversion for database mydb: 1603145 pages completed.
Cross-platform conversion for database mydb: 1669947 pages completed.
Cross-platform conversion for database mydb: 1736757 pages completed.
Cross-platform conversion for database mydb: 1803567 pages completed.
Cross-platform conversion for database mydb: 1870377 pages completed.
Cross-platform conversion for database mydb: 1937187 pages completed.
Cross-platform conversion for database mydb: 2003997 pages completed.
Cross-platform conversion for database mydb: 2070807 pages completed.
Cross-platform conversion for database mydb: 2137617 pages completed.
Cross-platform conversion for database mydb: 2204427 pages completed.
Cross-platform conversion for database mydb: 2271237 pages completed.
Cross-platform conversion for database mydb: 2338047 pages completed.
Cross-platform conversion for database mydb: 2404857 pages completed.
Cross-platform conversion for database mydb: 2471667 pages completed.
Cross-platform conversion for database mydb: 2538477 pages completed.
Cross-platform conversion for database mydb: 2605287 pages completed.
Cross-platform conversion for database mydb: 2672097 pages completed.
Cross-platform conversion for database mydb: 2738907 pages completed.
Cross-platform conversion for database mydb: 2805717 pages completed.
Cross-platform conversion for database mydb: 2872527 pages completed.
Cross-platform conversion for database mydb: 2939337 pages completed.
Cross-platform conversion for database mydb: 3006131 pages completed.
Cross-platform conversion for database mydb: 3072941 pages completed.
Cross-platform conversion for database mydb: 3139751 pages completed.
Cross-platform conversion for database mydb: 3206561 pages completed.
Cross-platform conversion for database mydb: 3273371 pages completed.
Cross-platform conversion for database mydb: 3340181 pages completed.
Cross-platform conversion for database mydb: 3406991 pages completed.
Cross-platform conversion for database mydb: 3473801 pages completed.
Cross-platform conversion for database mydb: 3540603 pages completed.
Cross-platform conversion for database mydb: 3607413 pages completed.
Cross-platform conversion for database mydb: 3674223 pages completed.
Cross-platform conversion for database mydb: 3741009 pages completed.
Cross-platform conversion for database mydb: 3807819 pages completed.
Cross-platform conversion for database mydb: 3874629 pages completed.
Cross-platform conversion for database mydb: 3941439 pages completed.
Cross-platform conversion for database mydb: 4008249 pages completed.
Cross-platform conversion for database mydb: 4075059 pages completed.
Cross-platform conversion for database mydb: 4141862 pages completed.
Cross-platform conversion for database mydb: 4208672 pages completed.
Cross-platform conversion for database mydb: 4275482 pages completed.
Cross-platform conversion for database mydb: 4342292 pages completed.
Cross-platform conversion for database mydb: 4409102 pages completed.
Cross-platform conversion for database mydb: 4475912 pages completed.
Cross-platform conversion for database mydb: 4542714 pages completed.
Cross-platform conversion for database mydb: 4609524 pages completed.
Cross-platform conversion for database mydb: 4676334 pages completed.
Cross-platform conversion for database mydb: 4743144 pages completed.
Cross-platform conversion for database mydb: 4809954 pages completed.
Cross-platform conversion for database mydb: 4876764 pages completed.
Cross-platform conversion for database mydb: 4943574 pages completed.
Cross-platform conversion for database mydb: 5010384 pages completed.
Cross-platform conversion for database mydb: 5077194 pages completed.
Cross-platform conversion for database mydb: 5144004 pages completed.
Cross-platform conversion for database mydb: 5210814 pages completed.
Cross-platform conversion for database mydb: 5277624 pages completed.
Cross-platform conversion for database mydb: 5344434 pages completed.
Cross-platform conversion for database mydb: 5411244 pages completed.
Cross-platform conversion for database mydb: 5478054 pages completed.
Cross-platform conversion for database mydb: 5544864 pages completed.
Cross-platform conversion for database mydb: 5611674 pages completed.
Cross-platform conversion for database mydb: 5678484 pages completed.
Cross-platform conversion for database mydb: 5745294 pages completed.
Cross-platform conversion for database mydb: 5812104 pages completed.
Cross-platform conversion for database mydb: 5878914 pages completed.
Cross-platform conversion for database mydb: 5945708 pages completed.
Cross-platform conversion for database mydb: 6012518 pages completed.
Cross-platform conversion for database mydb: 6079328 pages completed.
Cross-platform conversion for database mydb: 6146138 pages completed.
Cross-platform conversion for database mydb: 6212948 pages completed.
Cross-platform conversion for database mydb: 6279750 pages completed.
Cross-platform conversion for database mydb: 6346560 pages completed.
Cross-platform conversion for database mydb: 6413370 pages completed.
Cross-platform conversion for database mydb: 6480180 pages completed.
Cross-platform conversion for database mydb: 6546990 pages completed.
Cross-platform conversion for database mydb: 6613800 pages completed.
Cross-platform conversion for database mydb: 6629355 pages completed.
Completed cross-platform conversion for user objects.
Started cross-platform conversion for log records.
Msg 3151, Level 16, State 2:
Server 'LINUX1', 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.

Thanks
Amal

unknown

2009-12-03 05:20:46 UTC

Permalink

Does your developer edition have a DB size limitation? The express edition had a 5GB limitation.
Do you use replication on that database? Was the LTM flag still there during the dump?
--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

Post by unknown
Hello,
I am trying to load a backup taken on IBM PowerPC server running AIX 5.2 and
ASE 15.0.2 to a Sun xVM virtual machine running RHEL 5 (on WinXP) and Sybase
ASE 15.0.3 Developer edition. The load is unsuccessful and here is the whole
message list. The DB load is successful portion goes into the Backup log but
not the messages appearing thereafter. When it is doing Cross platform
conversion of the log it gives an error message that the DB was not
quiesced. Why is that necessary. I did this first time so it said keep the
server in single user, do sp_flushstats so I did that and again took a
backup. But it continues to give this error at the fag end of the load.
The message below are from the screen.
1> create database mydb on mydbdata1=7500, mydblog1=1000, mydbdata2=1000 log
on mydbdata1=1000, mydblog1=2500 with override for load
2> go
CREATE DATABASE: allocating 3840000 logical pages (7500.0 megabytes) on disk
'mydbdata1'.
CREATE DATABASE: allocating 512000 logical pages (1000.0 megabytes) on disk
'mydblog1'.
CREATE DATABASE: allocating 512000 logical pages (1000.0 megabytes) on disk
'mydbdata2'.
CREATE DATABASE: allocating 512000 logical pages (1000.0 megabytes) on disk
'mydbdata1'.
CREATE DATABASE: allocating 1280000 logical pages (2500.0 megabytes) on disk
'mydblog1'.
Caution: You have set up this database to include space on disk 4 for both
data and the transaction log. This can make recovery impossible if that
disk fails.
Caution: You have set up this database to include space on disk 6 for both
data and the transaction log. This can make recovery impossible if that
disk fails.
Processed 2600 allocation unit(s) out of 26000 units (allocation page
665344). 10% completed.
Processed 5200 allocation unit(s) out of 26000 units (allocation page
1330944). 20% completed.
Processed 7800 allocation unit(s) out of 26000 units (allocation page
1996544). 30% completed.
Processed 10400 allocation unit(s) out of 26000 units (allocation page
2662144). 40% completed.
Processed 13000 allocation unit(s) out of 26000 units (allocation page
3327744). 50% completed.
Processed 15600 allocation unit(s) out of 26000 units (allocation page
3993344). 60% completed.
Processed 18200 allocation unit(s) out of 26000 units (allocation page
4658944). 70% completed.
Processed 20800 allocation unit(s) out of 26000 units (allocation page
5324544). 80% completed.
Processed 23400 allocation unit(s) out of 26000 units (allocation page
5990144). 90% completed.
Processed 26000 allocation unit(s) out of 26000 units (allocation page
6655744). 100% completed.
1> select db_name()
2> go
------------------------------------------------------------
master
(1 row affected)
1> load database mydb from 'compress::6::/opt/sybase/mydb201109.dmp'
2> go
Backup Server session id is: 7. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
'compress::6::/opt/sybase/mydb201109.dmp::00'
Backup Server: 6.28.1.1: Dumpfile name 'mydb0932407B98 ' section number 1
mounted on byte stream 'compress::6::/opt/sybase/mydb201109.dmp::00'
Backup Server: 4.188.1.1: Database mydb: 140636 kilobytes (1%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 276212 kilobytes (2%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 402634 kilobytes (3%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 539874 kilobytes (4%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 669690 kilobytes (5%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 799506 kilobytes (6%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 944744 kilobytes (7%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1074746 kilobytes (8%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1204364 kilobytes (9%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1334366 kilobytes (10%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1478642 kilobytes (11%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1608260 kilobytes (12%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1738262 kilobytes (13%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1867880 kilobytes (14%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 1997882 kilobytes (15%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2142158 kilobytes (16%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2271776 kilobytes (17%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2401778 kilobytes (18%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2531396 kilobytes (19%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2675672 kilobytes (20%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2805290 kilobytes (21%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 2935292 kilobytes (22%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3064910 kilobytes (23%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3202142 kilobytes (24%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3340526 kilobytes (25%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3461564 kilobytes (26%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3599820 kilobytes (27%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3738204 kilobytes (28%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3876972 kilobytes (29%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 3998010 kilobytes (30%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4136394 kilobytes (31%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4274778 kilobytes (32%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4396200 kilobytes (33%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4534584 kilobytes (34%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4672968 kilobytes (35%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4794006 kilobytes (36%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 4932328 kilobytes (37%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5071158 kilobytes (38%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5192196 kilobytes (39%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5330580 kilobytes (40%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5468964 kilobytes (41%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5607732 kilobytes (42%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5728770 kilobytes (43%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 5867154 kilobytes (44%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6005538 kilobytes (45%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6126960 kilobytes (46%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6265344 kilobytes (47%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6403728 kilobytes (48%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6524766 kilobytes (49%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6663088 kilobytes (50%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6801918 kilobytes (51%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 6922956 kilobytes (52%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7061340 kilobytes (53%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7199724 kilobytes (54%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7338492 kilobytes (55%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7459530 kilobytes (56%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7597914 kilobytes (57%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7736298 kilobytes (58%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7857720 kilobytes (59%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 7996104 kilobytes (60%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8134488 kilobytes (61%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8253738 kilobytes (62%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8394372 kilobytes (63%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8524188 kilobytes (64%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8654004 kilobytes (65%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8794638 kilobytes (66%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 8924454 kilobytes (67%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9054270 kilobytes (68%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9194904 kilobytes (69%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9324720 kilobytes (70%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9454536 kilobytes (71%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9595170 kilobytes (72%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9724986 kilobytes (73%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9854802 kilobytes (74%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 9984618 kilobytes (75%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10125252 kilobytes (76%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10255068 kilobytes (77%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10384884 kilobytes (78%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10525518 kilobytes (79%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10655334 kilobytes (80%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10785150 kilobytes (81%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 10925784 kilobytes (82%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11055600 kilobytes (83%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11185416 kilobytes (84%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11315232 kilobytes (85%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11455866 kilobytes (86%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11585682 kilobytes (87%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11715498 kilobytes (88%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11856132 kilobytes (89%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 11985948 kilobytes (90%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12115764 kilobytes (91%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12256398 kilobytes (92%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12386214 kilobytes (93%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12516030 kilobytes (94%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12656664 kilobytes (95%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12786480 kilobytes (96%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 12916296 kilobytes (97%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 13046112 kilobytes (98%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 13186746 kilobytes (99%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 13314002 kilobytes (100%) LOADED.
Backup Server: 4.188.1.1: Database mydb: 13314014 kilobytes (100%) LOADED.
Backup Server: 3.42.1.1: LOAD is complete (database mydb).
Started cross-platform conversion for database mydb.
Started cross-platform conversion for system objects.
Cross-platform conversion for database mydb: 10000 pages completed.
Cross-platform conversion for database mydb: 20000 pages completed.
Cross-platform conversion for database mydb: 26624 pages completed.
Completed cross-platform conversion for system objects.
Started cross-platform conversion for user objects.
Cross-platform conversion for database mydb: 66658 pages completed.
Cross-platform conversion for database mydb: 133460 pages completed.
Cross-platform conversion for database mydb: 200270 pages completed.
Cross-platform conversion for database mydb: 266985 pages completed.
Cross-platform conversion for database mydb: 333787 pages completed.
Cross-platform conversion for database mydb: 400597 pages completed.
Cross-platform conversion for database mydb: 467391 pages completed.
Cross-platform conversion for database mydb: 534193 pages completed.
Cross-platform conversion for database mydb: 601003 pages completed.
Cross-platform conversion for database mydb: 667813 pages completed.
Cross-platform conversion for database mydb: 734623 pages completed.
Cross-platform conversion for database mydb: 801433 pages completed.
Cross-platform conversion for database mydb: 868243 pages completed.
Cross-platform conversion for database mydb: 935053 pages completed.
Cross-platform conversion for database mydb: 1001863 pages completed.
Cross-platform conversion for database mydb: 1068673 pages completed.
Cross-platform conversion for database mydb: 1135483 pages completed.
Cross-platform conversion for database mydb: 1202285 pages completed.
Cross-platform conversion for database mydb: 1269095 pages completed.
Cross-platform conversion for database mydb: 1335905 pages completed.
Cross-platform conversion for database mydb: 1402715 pages completed.
Cross-platform conversion for database mydb: 1469525 pages completed.
Cross-platform conversion for database mydb: 1536335 pages completed.
Cross-platform conversion for database mydb: 1603145 pages completed.
Cross-platform conversion for database mydb: 1669947 pages completed.
Cross-platform conversion for database mydb: 1736757 pages completed.
Cross-platform conversion for database mydb: 1803567 pages completed.
Cross-platform conversion for database mydb: 1870377 pages completed.
Cross-platform conversion for database mydb: 1937187 pages completed.
Cross-platform conversion for database mydb: 2003997 pages completed.
Cross-platform conversion for database mydb: 2070807 pages completed.
Cross-platform conversion for database mydb: 2137617 pages completed.
Cross-platform conversion for database mydb: 2204427 pages completed.
Cross-platform conversion for database mydb: 2271237 pages completed.
Cross-platform conversion for database mydb: 2338047 pages completed.
Cross-platform conversion for database mydb: 2404857 pages completed.
Cross-platform conversion for database mydb: 2471667 pages completed.
Cross-platform conversion for database mydb: 2538477 pages completed.
Cross-platform conversion for database mydb: 2605287 pages completed.
Cross-platform conversion for database mydb: 2672097 pages completed.
Cross-platform conversion for database mydb: 2738907 pages completed.
Cross-platform conversion for database mydb: 2805717 pages completed.
Cross-platform conversion for database mydb: 2872527 pages completed.
Cross-platform conversion for database mydb: 2939337 pages completed.
Cross-platform conversion for database mydb: 3006131 pages completed.
Cross-platform conversion for database mydb: 3072941 pages completed.
Cross-platform conversion for database mydb: 3139751 pages completed.
Cross-platform conversion for database mydb: 3206561 pages completed.
Cross-platform conversion for database mydb: 3273371 pages completed.
Cross-platform conversion for database mydb: 3340181 pages completed.
Cross-platform conversion for database mydb: 3406991 pages completed.
Cross-platform conversion for database mydb: 3473801 pages completed.
Cross-platform conversion for database mydb: 3540603 pages completed.
Cross-platform conversion for database mydb: 3607413 pages completed.
Cross-platform conversion for database mydb: 3674223 pages completed.
Cross-platform conversion for database mydb: 3741009 pages completed.
Cross-platform conversion for database mydb: 3807819 pages completed.
Cross-platform conversion for database mydb: 3874629 pages completed.
Cross-platform conversion for database mydb: 3941439 pages completed.
Cross-platform conversion for database mydb: 4008249 pages completed.
Cross-platform conversion for database mydb: 4075059 pages completed.
Cross-platform conversion for database mydb: 4141862 pages completed.
Cross-platform conversion for database mydb: 4208672 pages completed.
Cross-platform conversion for database mydb: 4275482 pages completed.
Cross-platform conversion for database mydb: 4342292 pages completed.
Cross-platform conversion for database mydb: 4409102 pages completed.
Cross-platform conversion for database mydb: 4475912 pages completed.
Cross-platform conversion for database mydb: 4542714 pages completed.
Cross-platform conversion for database mydb: 4609524 pages completed.
Cross-platform conversion for database mydb: 4676334 pages completed.
Cross-platform conversion for database mydb: 4743144 pages completed.
Cross-platform conversion for database mydb: 4809954 pages completed.
Cross-platform conversion for database mydb: 4876764 pages completed.
Cross-platform conversion for database mydb: 4943574 pages completed.
Cross-platform conversion for database mydb: 5010384 pages completed.
Cross-platform conversion for database mydb: 5077194 pages completed.
Cross-platform conversion for database mydb: 5144004 pages completed.
Cross-platform conversion for database mydb: 5210814 pages completed.
Cross-platform conversion for database mydb: 5277624 pages completed.
Cross-platform conversion for database mydb: 5344434 pages completed.
Cross-platform conversion for database mydb: 5411244 pages completed.
Cross-platform conversion for database mydb: 5478054 pages completed.
Cross-platform conversion for database mydb: 5544864 pages completed.
Cross-platform conversion for database mydb: 5611674 pages completed.
Cross-platform conversion for database mydb: 5678484 pages completed.
Cross-platform conversion for database mydb: 5745294 pages completed.
Cross-platform conversion for database mydb: 5812104 pages completed.
Cross-platform conversion for database mydb: 5878914 pages completed.
Cross-platform conversion for database mydb: 5945708 pages completed.
Cross-platform conversion for database mydb: 6012518 pages completed.
Cross-platform conversion for database mydb: 6079328 pages completed.
Cross-platform conversion for database mydb: 6146138 pages completed.
Cross-platform conversion for database mydb: 6212948 pages completed.
Cross-platform conversion for database mydb: 6279750 pages completed.
Cross-platform conversion for database mydb: 6346560 pages completed.
Cross-platform conversion for database mydb: 6413370 pages completed.
Cross-platform conversion for database mydb: 6480180 pages completed.
Cross-platform conversion for database mydb: 6546990 pages completed.
Cross-platform conversion for database mydb: 6613800 pages completed.
Cross-platform conversion for database mydb: 6629355 pages completed.
Completed cross-platform conversion for user objects.
Started cross-platform conversion for log records.
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.
Thanks
Amal

zionassedo

2014-01-08 03:52:52 UTC

Permalink

It is a known issue that in cross-platform you must be sure that the source database is not in activity.
You have 2 methods :
1) put the source db in single user mode, empty the transaction log and perform the dump
2) empty the transaction log, quiesce the db and dump it

The second option is more secure because the quiesce command "freezes" the database.

After loading and online the database you will have to check the indexes, they get frequently corrupted during the operation.