TSM Server 5.4.3.2 TSM Client 5.5.1.0 on Windows 2003 SP2 x64 w/SQLServer 2005 TDP Client 5.5.2.0
When a restore request came in for a particular SQLServer instance, I discovered that the daily diff backups of all but 2 databases in that instance had been failing since last October, with the following error message: ANS0328E (RC45) The specified objects failed the merge test. I have encountered this before, so I know about the limitation of not changing mgmtclasses on these types of clients. Here are the things that puzzle me about this: 1. All of my SQL Server nodes backup under a common nodename (in order to make cross-server restores easier). I use client option sets to control the mgmtclasses, so how could every other SQL backup be working except this one, since they are all using the same nodename and policy? Note - they each have their own nodename for scheduling, the script they run then uses an optfile that contains the common nodename for the backup itself. 2. Why would the full backups work, and the diffs fail? Why is one instance failing, and the other one working? And then, why are 2 of the databases working, and all the rest failing? I would have thought that this problem would lead to any backup failing? 3. According the the DBA's, SQLServer is recording a successful backup every time - this is the most disturbing, since it prevented us from detecting this failure until too late. Part of the problem is that the error code (402) is the same one that we see for offline databases, which led to the failures being dismissed by our Admin team as "normal". TIA, Steve Schaub Systems Engineer II, Windows Backup/Recovery BlueCross BlueShield of Tennessee ----------------------------------------------------- Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
