TDP SQL backup is failing

[madbug0]

Hi,

Need a urgent help as tdp for sql backup failing. Currnet tsm version is 5521 and tdpversion is 5331.

08/25/2009 17:15:13 Backup of master failed.
08/25/2009 17:15:13 ACO5422E Received the following from the MS SQL server:
08/25/2009 17:15:13 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'TDPSQL-0000019C-0000'. Operating system error 0x80770006(error not found).
08/25/2009 17:15:13 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80040c81)

 

[randyman]

We are getting very similar problems. Any resolution?

09/02/2009 21:00:58 ACO5422E Received the following from the MS SQL server:
09/02/2009 21:00:58 An exception occurred while executing a Transact-SQL statement or batch.
09/02/2009 21:00:58 Cannot open backup device 'TDPSQL-00001194-0000'. Operating system error 0x80770006(error not found).

09/02/2009 21:00:58 BACKUP DATABASE is terminating abnormally.

 

[THE_WIPET]

Did you reinstall your BA client and TDP... look like the API is freaking out!

 

[randyman]

Yes, I uninstalled it all and reinstalled. TSM client v5.5.1.0, TDP SQL v5.5.0.0. Windows 2003 x64 server with SQL Server 2005. TSM Server is Winows 2003 x64, TSMEE v5.5.2.1. Here's more info from the event viewer on the client:

Event Type: Error
Event Source: SQLVDI
Event Category: None
Event ID: 1
Date: 9/3/2009
Time: 10:25:02 AM
User: N/A
Computer: SDBS250
Description:
SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=3868. Thread=2648. Client. Instance=. VD=Global\TDPSQL-00000F1C-0000_SQLVDIMemoryName_0.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

FOLLOWED BY:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 3201
Date: 9/3/2009
Time: 10:25:02 AM
User: XXXXXXXXX
Computer: XXXX
Description:
Cannot open backup device 'TDPSQL-00000F1C-0000'. Operating system error 0x80770006(error not found).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 81 0c 00 00 10 00 00 00 .......
0008: 08 00 00 00 53 00 44 00 ....S.D.
0010: 42 00 53 00 32 00 35 00 B.S.2.5.
0018: 30 00 00 00 0b 00 00 00 0.......
0020: 71 00 61 00 5f 00 68 00 q.a._.h.
0028: 62 00 73 00 30 00 31 00 b.s.0.1.
0030: 5f 00 62 00 00 00 _.b...

AND:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 3041
Date: 9/3/2009
Time: 10:25:02 AM
User: XXXXX
Computer: XXXX
Description:
BACKUP failed to complete the command BACKUP DATABASE qa_hbs01_b. Check the backup application log for detailed messages.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: e1 0b 00 00 10 00 00 00 á.......
0008: 08 00 00 00 53 00 44 00 ....S.D.
0010: 42 00 53 00 32 00 35 00 B.S.2.5.
0018: 30 00 00 00 0b 00 00 00 0.......
0020: 71 00 61 00 5f 00 68 00 q.a._.h.
0028: 62 00 73 00 30 00 31 00 b.s.0.1.
0030: 5f 00 62 00 00 00 _.b...


IN THE TSM LOGS, ALL DATABASES FAIL WITH THIS ERROR:

09/02/2009 21:01:01 Backup of QuestWorkDatabase failed.
09/02/2009 21:01:01 ACO5422E Received the following from the MS SQL server:
09/02/2009 21:01:01 An exception occurred while executing a Transact-SQL statement or batch.
09/02/2009 21:01:01 Cannot open backup device 'TDPSQL-00001194-0000'. Operating system error 0x80770006(error not found).

09/02/2009 21:01:01 BACKUP DATABASE is terminating abnormally.

 

[THE_WIPET]

OK.. try to "dump" the database into a flatfile throught the MS Sql interface.. This could pin point the problem.. If you cannot backup the database from MS SQL console.. the probleme might be SQL and not the TDP..

The other option is to install the lastest vesion of the BA(5.5.2.2) and TDP(5.5.2.1)

Was it working before?? is this a new installation?? Did any upgrade happen SQl and OS??

 

[randyman]

No, it is not a new install, its been working for some time now. No upgrades. I have the SQL guys looking at it now. I'll post any findings.

 

[randyman]

Still fighting this issue. SQL team was able to run a backup to file.

09/08/2009 21:00:37 ACO5422E Received the following from the MS SQL server:
09/08/2009 21:00:37 An exception occurred while executing a Transact-SQL statement or batch.
09/08/2009 21:00:37 Cannot open backup device 'TDPSQL-000003E0-0000'. Operating system error 0x80770006(error not found).

09/08/2009 21:00:37 BACKUP DATABASE is terminating abnormally.

 

[THE_WIPET]

OK.. Try upgrading the BA et TDP.. ONe other Thing.. is the security of the DB as change??? Do you backup trought SA or an account???

 

[d.veeresh]

Hi,

may be problem with access. update in dsm.opt with PASSWORDACCESS GENERATE, check with user id and password.

 

[randyman]

I've reinstalled the baclient and TDP. Working with the server owner to schedule a reboot. I bet you anything that will fix it. Gotta love windows.

 

[THE_WIPET]

hehehe... Keep us posted if the reboot solve the problem... always nice to know

 

[randyman]

This is a shocking resolution: Reinstalled both baclient and TDP and REBOOTED WINDOWS SERVER. All is now good.

 

[THE_WIPET]

Dont blame windows on this.. Got an issue with SAP on Solaris.. Redo logs where working.. but the full failed... had to reinstalled the TDP SAP agent et reboot the SAP server.. after this everything was working..

 

[jmcgheenc]

reboot?

Have you rebooted the sql box?
Once a week we get a virtual memory error "BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device 'TDPSQL-000011E0-0000'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.)."

I reboot the box and we're good for a week. TDP uses up the virtual memory space on the sql box, and we also have some CLR code that runs too, which also plays in that virtual memory space also. It's SQL Server 2005, clustered.