Welcome! » Log In » Create A New Profile

Error in sqlserver backups

Posted by Anonymous 
Error in sqlserver backups
March 24, 2010 12:04PM
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

=
Error in sqlserver backups
March 24, 2010 12:08PM
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] 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
Error in sqlserver backups
March 24, 2010 12:11PM
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] 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
Error in sqlserver backups
March 24, 2010 12:17PM
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:

[quote][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
[/quote]parameters.
[quote]
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

[/quote]
Error in sqlserver backups
March 24, 2010 12:18PM
On Mar 24, 2010, at 3:03 PM, Lee, Gary D. wrote:

[quote]Checked BA manual, the word merge does not appear in the entire manual. What now?
[/quote]
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
Sorry, only registered users may post in this forum.

Click here to login