SearchFAQMemberlist Log in
Reply to topic Page 1 of 1
Error in sqlserver backups
Author Message
Post Error in sqlserver backups 
Tsm server v5.5.4
Tdp for sql 5.5.3.

Just figured out the ability to put metadata into a separate stgpool. We also now had a request to move a db backup into a long term retention management class.

Added the include statements to dsm.opt, now when attempting the full backup for the long term retain, get the following.

03/24/2010 14:15:40 ACO5436E A failure occurred on stripe number (0), rc = 1301
03/24/2010 14:15:40 ANS0328E (RC45) The specified objects failed the merge test.
03/24/2010 14:15:40 ACO5436E A failure occurred on stripe number (0), rc = 1301
03/24/2010 14:15:40 ANS0328E (RC45) The specified objects failed the merge test.
03/24/2010 14:15:40 Backup of TRACKING_BLACKBOARD failed.

Looked in the tdp for sql manual, ans0328e not found. Aco3654 says check other messages for real error.
Found ans0328e in the ba command line help, says see test merge parameters.

Checked BA manual, the word merge does not appear in the entire manual. What now?

Thanks for the help.

Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

=

Post Error in sqlserver backups 
I ran into the same. My solution was to rename the existing filespace as oldmeta and olddata. I kept those until the new filespaces had been around as long as the original retention period.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L < at > vm.marist.edu] On Behalf Of Lee, Gary D.
Sent: Wednesday, March 24, 2010 2:04 PM
To: ADSM-L < at > vm.marist.edu
Subject: [ADSM-L] Error in sqlserver backups

Tsm server v5.5.4
Tdp for sql 5.5.3.

Just figured out the ability to put metadata into a separate stgpool. We also now had a request to move a db backup into a long term retention management class.

Added the include statements to dsm.opt, now when attempting the full backup for the long term retain, get the following.

03/24/2010 14:15:40 ACO5436E A failure occurred on stripe number (0), rc = 1301
03/24/2010 14:15:40 ANS0328E (RC45) The specified objects failed the merge test.
03/24/2010 14:15:40 ACO5436E A failure occurred on stripe number (0), rc = 1301
03/24/2010 14:15:40 ANS0328E (RC45) The specified objects failed the merge test.
03/24/2010 14:15:40 Backup of TRACKING_BLACKBOARD failed.

Looked in the tdp for sql manual, ans0328e not found. Aco3654 says check other messages for real error.
Found ans0328e in the ba command line help, says see test merge parameters.

Checked BA manual, the word merge does not appear in the entire manual. What now?

Thanks for the help.

Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

Post Error in sqlserver backups 
This one has appeared on here before:

Search for 'merge test' in here:
http://www-01.ibm.com/support/docview.wss?uid=swg21230975

"Changing backup management classes
"The following message may appear when changing management classes for
backups:
ANS0328E (RC45) The specified objects failed the merge test.
This can be caused when the meta data objects and the data objects of Data
Protection for SQL backups are bound to a different management class from
previous backups and if the meta data objects and data objects have
different copy destinations (APAR IC33026). You can workaround this issue by
creating a new NODENAME to be used for all future backups."

/DMc

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L < at > VM.MARIST.EDU] On Behalf Of
Lee, Gary D.
Sent: 24 March 2010 19:04
To: ADSM-L < at > VM.MARIST.EDU
Subject: [ADSM-L] Error in sqlserver backups

Tsm server v5.5.4
Tdp for sql 5.5.3.

Just figured out the ability to put metadata into a separate stgpool. We
also now had a request to move a db backup into a long term retention
management class.

Added the include statements to dsm.opt, now when attempting the full backup
for the long term retain, get the following.

03/24/2010 14:15:40 ACO5436E A failure occurred on stripe number (0), rc =
1301
03/24/2010 14:15:40 ANS0328E (RC45) The specified objects failed the merge
test.
03/24/2010 14:15:40 ACO5436E A failure occurred on stripe number (0), rc =
1301
03/24/2010 14:15:40 ANS0328E (RC45) The specified objects failed the merge
test.
03/24/2010 14:15:40 Backup of TRACKING_BLACKBOARD failed.

Looked in the tdp for sql manual, ans0328e not found. Aco3654 says check
other messages for real error.
Found ans0328e in the ba command line help, says see test merge parameters.

Checked BA manual, the word merge does not appear in the entire manual.
What now?

Thanks for the help.

Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

Post Error in sqlserver backups 
http://www-01.ibm.com/support/docview.wss?uid=swg21230975

This is an older problem originally documented in APAR IC33026.

Changing backup management classes
The following message may appear when changing management
classes for backups:
ANS0328E (RC45) The specified objects failed the merge test.
This can be caused when the meta data objects and the data objects
of Data Protection for SQL backups are bound to a different management
class from previous backups and if the meta data objects
and data objects have different copy destinations (APAR IC33026).
You can workaround this issue by creating a new NODENAME to be
used for all future backups.

Thanks,

Del

----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L < at > vm.marist.edu> wrote on 03/24/2010
03:03:32 PM:

[image removed]

Error in sqlserver backups

Lee, Gary D.

to:

ADSM-L

03/24/2010 03:04 PM

Sent by:

"ADSM: Dist Stor Manager" <ADSM-L < at > vm.marist.edu>

Please respond to "ADSM: Dist Stor Manager"

Tsm server v5.5.4
Tdp for sql 5.5.3.

Just figured out the ability to put metadata into a separate
stgpool. We also now had a request to move a db backup into a long
term retention management class.

Added the include statements to dsm.opt, now when attempting the
full backup for the long term retain, get the following.

03/24/2010 14:15:40 ACO5436E A failure occurred on stripe number
(0), rc = 1301
03/24/2010 14:15:40 ANS0328E (RC45) The specified objects failed
the merge test.
03/24/2010 14:15:40 ACO5436E A failure occurred on stripe number
(0), rc = 1301
03/24/2010 14:15:40 ANS0328E (RC45) The specified objects failed
the merge test.
03/24/2010 14:15:40 Backup of TRACKING_BLACKBOARD failed.

Looked in the tdp for sql manual, ans0328e not found. Aco3654 says
check other messages for real error.
Found ans0328e in the ba command line help, says see test merge
parameters.

Checked BA manual, the word merge does not appear in the entire
manual. What now?

Thanks for the help.

Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310



Post Error in sqlserver backups 
On Mar 24, 2010, at 3:03 PM, Lee, Gary D. wrote:

Checked BA manual, the word merge does not appear in the entire manual. What now?

TDPs employ the TSM API, where return code 45 is an API result documented in its manual, along with the interface functions associated with it.
Understanding the API is not as easy as understanding the B/A client, however.

Richard Sims

Display posts from previous:
Reply to topic Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
  


Magic SEO URL for phpBB