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 > DB2 > Restore SQL2570N

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-10-06, 02:37
Astroboy Astroboy is offline
Registered User
 
Join Date: Sep 2004
Posts: 5
Restore SQL2570N

Anyone know why I would get an SQL2570N error when trying to do a restore? Full error message:

SQL2570N
A database cannot be restored on a platform that does not match the platform on which the backup image was created.

I'm backing up and restoring from the same machine (DB2 8.2 on WinXP). I've tried running the restore on a different machine and get the same error.

Any ideas?
Reply With Quote
  #2 (permalink)  
Old 08-10-06, 03:24
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
Do a db2ckbkp on the image and check if backup is valid
Sathyaram
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #3 (permalink)  
Old 08-10-06, 11:26
Astroboy Astroboy is offline
Registered User
 
Join Date: Sep 2004
Posts: 5
This is what I got on the db2ckbkp -h:
ERROR: Failed to verify media header. Cannot continue.

Is there a way to find out what is wrong with the backup? The backup didn't indicate any error messages. It just said it backed up successfully.
Reply With Quote
  #4 (permalink)  
Old 08-10-06, 11:53
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
i think bkp image somehow got corrupted.
you have to make a fresh BKP and try restoreing it again.

Rahul Singh
Reply With Quote
  #5 (permalink)  
Old 08-10-06, 13:33
Astroboy Astroboy is offline
Registered User
 
Join Date: Sep 2004
Posts: 5
Unfortunately i've already tried to make another backup. Same result. Could it be that DB2 is creating bad backups?
Reply With Quote
  #6 (permalink)  
Old 08-10-06, 15:26
Astroboy Astroboy is offline
Registered User
 
Join Date: Sep 2004
Posts: 5
After doing some digging with a collegue, we found that the dbm release level was not the same as the db release level (0x0900 and 0x0a00 respectively). For some reason the db2 version installed was not proper.

Thanks all who replied.
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