Error while trying to restore SQL DB to another server

priya_bp

Active Newcomer
Joined
Jun 13, 2007
Messages
5
Reaction score
0
Points
0
PREDATAR Control23

Hi,

I am trying to restore one SQL db to another (target) server. I have created a separate OPT file in target server pointing to the source server. When i start th e restore, getting the below error. Can anyone assist?

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 5, Release 5, Level 5.0
(C) Copyright IBM Corporation 1997, 2010. All rights reserved.
Connecting to SQL Server, please wait...
Starting Sql database restore...
Connecting to TSM Server as node 'xxx-tdp'...
Querying Tivoli Storage Manager server for a list of database backups, please wait...

ANS1245E (RC122) The file has an unknown format.

Press any key to continue . . .

Please find the version details for source and destination server below.
Source Server:

TSM BA Client version - 6.3.2.0
TDP for SQL version - 5.5.5.0

Destination server:

TSM BA Client version - 6.3.0.0
TDP for SQL version - 5.5.5.0
Please help!!
Thanks in advance.
 
PREDATAR Control23

That error can happen if the TSM API used to perform the restore is older than the version used to perform the backup.

First Google hit for ANS1245E (RC122) treats that specific situation: http://www-01.ibm.com/support/docview.wss?uid=swg21191230

This appears to be exactly what is happening here, your destination has an older client than the source.
 
PREDATAR Control23

Hi Marclant,

Thanks for your reply!! Let me upgrade the destination to 6.3.2.0 and have a try.
Will keep you posted.:up:
 
Top