Windows SQL backup is missing

[tsmhelum]

Hello all,

We have a Windows SQL backup that keeps missing with the error below in the server log, I reset the password for the box that the SQL is running on and it did not correct the problem. The non SQL backup is completing successfully. If the password is the same for both backups why is the SQL backup missing. Any Ideas?

I have information below that may help

DSMERROLOG
04/27/2008 05:13:17 ANS2050E TSM needs to prompt for the password but cannot prompt because the process is running in the background.
04/27/2008 05:13:18 ANS2050E TSM needs to prompt for the password but cannot prompt because the process is running in the background.
04/27/2008 05:13:18 ANS2050E TSM needs to prompt for the password but cannot prompt because the process is running in the background.
04/27/2008 05:13:18 ANS1029E Communication with the TSM server is lost.
04/27/2008 10:35:56 ANS2050E TSM needs to prompt for the password but cannot prompt because the process is running in the background.
04/27/2008 10:35:56 ANS2050E TSM needs to prompt for the password but cannot prompt because the process is running in the background.
04/27/2008 10:35:56 ANS2050E TSM needs to prompt for the password but cannot prompt because the process is running in the background.
04/27/2008 10:35:56 ANS1029E Communication with the TSM server is lost.

DSMSCHED.LOG


04/27/2008 05:13:12 Querying server for next scheduled event.
04/27/2008 05:13:12 Node Name: SUTBWSQL
04/27/2008 05:13:17 ANS2050E TSM needs to prompt for the password but cannot prompt because the process is running in the background.
04/27/2008 05:13:18 ANS1262I Password is not updated. Either an invalid current password was supplied or the new password does not fulfill the server password requirements.
04/27/2008 05:13:18 ANS2050E TSM needs to prompt for the password but cannot prompt because the process is running in the background.
04/27/2008 05:13:18 ANS1262I Password is not updated. Either an invalid current password was supplied or the new password does not fulfill the server password requirements.
04/27/2008 05:13:18 ANS2050E TSM needs to prompt for the password but cannot prompt because the process is running in the background.
04/27/2008 05:13:18 ANS1262I Password is not updated. Either an invalid current password was supplied or the new password does not fulfill the server password requirements.
04/27/2008 05:13:18 ANS1029E Communication with the TSM server is lost.
04/27/2008 05:13:18 Scheduler has been stopped.

04/27/2008 10:35:56 Querying server for next scheduled event.
04/27/2008 10:35:56 Node Name: SUTBWSQL
04/27/2008 10:35:56 ANS2050E TSM needs to prompt for the password but cannot prompt because the process is running in the background.
04/27/2008 10:35:56 ANS1262I Password is not updated. Either an invalid current password was supplied or the new password does not fulfill the server password requirements.
04/27/2008 10:35:56 ANS2050E TSM needs to prompt for the password but cannot prompt because the process is running in the background.
04/27/2008 10:35:56 ANS1262I Password is not updated. Either an invalid current password was supplied or the new password does not fulfill the server password requirements.
04/27/2008 10:35:56 ANS2050E TSM needs to prompt for the password but cannot prompt because the process is running in the background.
04/27/2008 10:35:56 ANS1262I Password is not updated. Either an invalid current password was supplied or the new password does not fulfill the server password requirements.
04/27/2008 10:35:56 ANS1029E Communication with the TSM server is lost.
04/27/2008 10:35:56 Scheduler has been stopped.

SQL client command line shows the following when I click on it:

BM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 5, Release 2, Level 1.0
C) Copyright IBM Corporation 1997, 2003. All rights reserved.

choose from the following commands:

DPSQLC Backup *|dbname[,dbname,...] [Full]
[/BUFFers=numbuffers] default: 3 (or cfg value)
[/BUFFERSIze=buffersizeinkb] default: 1024 (or cfg value)
[/CONFIGfile=configfilename] default: tdpsql.cfg
[/LOGFile=logfilename] default: tdpsql.log (or cfg value)
[/LOGPrune=numdays|No] default: 60 (or cfg value)
press enter for more information.

Configuration

TSM 5.5.0
Windows 2000 OS/ TSM Client 5.5.0.2

Thanks for any help!

 

[bhaven41]

You should try updating your SQL scheduler (with node name SUTBWSQL) with correct password from BA client GUI -> Wizard -> update scheduler.

 

[spiffy]

You may need to reset the password of the node(reset SUTBWSQL node) on the TSM server, then go to the client and open the SQL Client GUI and it should prompt you for the password, type it in and away it should go.
I just ran into this problem this morning and this is what i did and it works now.

 

[moon-buddy]

If you fired up the TDP backup via command line, look for stale dos and tdpexch process. Kill them and the backup should run normally.

 

[tsmhelum]

bhaven41, spiffy and moon thanks for your replies!

I reset the password of the node SUTBWSQL on the tsm server then updated
The password using the BA client GUI >> setup wizard >>updated Data Proctection for SQL Scheduler. In doing so I received the following message(s)

Dsm

Error1 establishing TSM API session

The password is expired on the TSM Server

I hit >> OK

Then the following appears

DSM

Error 0 updating password the TSM Server

The password was successfully verified with the TSM Server

OK


However it did not correct the Issue


Also, When I start the Data Protection for SQL Scheduler it won

 

[bhaven41]

If your password is successfully verified with TSM Server and once you restart scheduler services, you backup should not miss next time.

After restating scheduler services, do you get new schedule in dsmsched.log file?


OR
try with command line

: dsmc -optfile="full path\dsm.opt" (opt file for SQL node)
(this may ask for password if it is not verified with tsm server and not stored - i assume you have passwordaccess is generate)

once you enter successfully, query schedule, come out and restart scheduler.

 

[tsmhelum]

bhaven41

Thanks! The command line worked

dsmc -optfile=" C:\Program Files\Tivoli\TSM\TDPSql\dsm.opt

it asked for the password I enterend it and got out. I then restarted the Data Protection for SQL Scheduler and it stayed Started this time.

Dsmsched.log now shows

04/29/2008 13:44:09 --- SCHEDULEREC QUERY BEGIN
04/29/2008 13:44:09 --- SCHEDULEREC QUERY END
04/29/2008 13:44:09 Next operation scheduled:
04/29/2008 13:44:09 ------------------------------------------------------------
04/29/2008 13:44:09 Schedule Name: MIDNIGHT
04/29/2008 13:44:09 Action: Command
04/29/2008 13:44:09 Objects: c:\sqlfull.cmd
04/29/2008 13:44:09 Options:
04/29/2008 13:44:09 Server Window Start: 21:00:00 on 04/29/2008
04/29/2008 13:44:09 ------------------------------------------------------------
04/29/2008 13:44:09 Waiting to be contacted by the server.


I appreciate all your help!