Home > Return Code > Tsm Tdp Sql Error 402

Tsm Tdp Sql Error 402

Contents

Previous message View by thread View by date Next message Re: TDP for SQL backup fails Yiannakis Vakis Re: TDP for SQL backup fails Richard Sims Re: TDP for SQL backup A return code of 402 from the TDP is a generic error and information needs to be gathered from other sources, such as the activity log, local error logs etc, Windows Make sure that the program waits for tape mounts. Return code = 402.

If yes, than I suspect Go to Solution 2 Comments LVL 12 Overall: Level 12 MS SQL Server 2008 7 Storage Software 2 Message Accepted Solution by:pastorchris2011-10-17 Hi, The error Watson Product Search Search None of the above, continue with my search IT04925: OPTION TO WAIT FOR MOUNTS IN DATA PROTECTION FOR SQL CONFIGURATION FILE AND MMC GUI IS NOT USED Therefore do not configure TDP to backup SQL database files directly. The message: ANS1360I Compressed Data Grew tell that you have "compression" enabled on the client. https://adsm.org/forum/index.php?threads/sql-tdp-schedule-failed-error-402.21003/

Ans1512e Scheduled Event Failed. Return Code = 402

hknd Active Newcomer Joined: Apr 8, 2010 Messages: 6 Likes Received: 0 Hi, TSM provides the following error when sql backup does not complete the schedule. It seems that there is a problem with one of the Storage Agent Server paths. I have turn down the path that was pointing to the drive 5 and the scheduled backups finishes without problem with the status "completed" For some odd reason, the backup always It save some network bandwidth and TSM server storage pool disk space.

Explanation: This message is displayed when a client reports failure in executing a scheduled action. Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility United States English English IBM® Site map IBM IBM Support Check here to The backup continues without problem, but it seems that this problem with the drive 5 produces the "failed 402" status on the backup schedule. Tsm Return Code 464 The online Knowledge Center provides further details on those two parameters.

In the Activity Log, pore over the entries during that period looking for any indication of the server waiting for a resource (where *one* case is ANR8319I and final ANR8351E when DMobley232 replied Oct 29, 2016 at 12:18 PM Help Understand Backup stgpool... vilius.m replied Oct 28, 2016 at 1:00 AM Tivoli 5.5.4 and Citrix XenServer pmaczka replied Oct 27, 2016 at 3:29 PM Replication question marclant replied Oct 27, 2016 at 2:23 PM http://www-01.ibm.com/support/docview.wss?uid=swg21647190 It could not be something to do with it?

System Action: Server operation continues. Ans1512e Scheduled Event Failed. Return Code = 418 Your cache administrator is webmaster. Error description When the 'MOUNTWaitfordata yes' is specified in the Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL configuration file (tdpsql.cfg), or if the 'Wait for Tape Mounts for Dnyaneshwar devadhe replied Nov 9, 2011 Hi, Thanks for the post..

Fmy0151e

Resolving the problem Increase the Max Mount Points Allowed (UPDATE NODE MAXNUMMP=#) of the node on the Tivoli Storage Manager server. https://www.experts-exchange.com/questions/27396898/TSM-Backup-for-SQL-says-completed-but-No-logs-for-completion.html There should be something in there. Ans1512e Scheduled Event Failed. Return Code = 402 ANS1312E (RC12) Server media mount not possible The weird thing is that you can see that there are some data that have been backed up before this error message. Ans1909e The Scheduled Command Failed APAR status Closed as program error.

Best Regards Daniel Sparrman ----------------------------------- Daniel Sparrman Exist i Stockholm AB Bergkällavägen 31D 192 79 SOLLENTUNA Växel: 08 - 754 98 00 Mobil: 070 - 399 27 51 Zoltan Forray/AC/VCU <[EMAIL The error message ANS1017E is unknown to my TSM. Make sure "MOUNTWaitfordata" is set to yes. Retrying failed backups... Ans1512e Return Code = 12

  1. I always recommend that you create SQL backup jobs to backup SQL server databases to a backup location on your server, then use TDP to backup the backup folder (where your
  2. Aroone aroon_e, May 5, 2010 #2 mccleld ADSM.ORG Senior Member Joined: Jun 24, 2003 Messages: 261 Likes Received: 7 Occupation: Data Protection Specialist Location: London, UK What was in the
  3. Cause This may be caused by insufficient mounts points on the Tivoli Storage Manager server Diagnosing the problem Check the Tivoli Storage Manager server activity log for the following error at
  4. There is a manual for these messages called "Tivoli Storage Manager Message Version 4 Release 2".
  5. United States English English IBM® Site map IBM IBM Support Check here to start a new keyword search.
  6. I didn't see them in the TDP for MS-SQL book ?
  7. DMobley232 replied Oct 29, 2016 at 12:17 PM Query Event and Query schedule...

Could someone help me to fix this issue? 11/07/2011 19:24:32 ANS1360I Compressed Data Grew 11/07/2011 19:24:38 ANS1360I Compressed Data Grew 11/08/2011 03:32:45 ANS1909E The scheduled command failed. 11/08/2011 03:32:45 ANS1512E Scheduled CONTINUE READING Join & Write a Comment Already a member? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses fidel replied Oct 28, 2016 at 5:04 AM RMAN archive logs stuck ?

It was nothing to do with the SQL database. Failed Error Rc 402 Aco0151e o0francois0o replied Oct 28, 2016 at 2:08 PM failed to open mailslot - LTO TSM moon-buddy replied Oct 28, 2016 at 9:21 AM 'Get rid of tape' - Migrate 1... Pierre Chapus replied Nov 9, 2011 Hi, I explain you some parts that may help, because I am not sure that the compression fact is related to the schedule error.

I suggest examining the TSM Server console log closely to find out.

All product names are trademarks of their respective companies. Toolbox for IT My Home Topics People Companies Jobs White Paper Library Collaboration Tools Discussion Groups Blogs Follow Toolbox.com Toolbox for IT on Twitter Toolbox.com on Twitter Toolbox.com on Facebook Topics Error messages: 1.message Schedule SQL-TDP in domain DAILYDOMAIN for node SQL-TDP failed (return code 402). (SESSION: 37945) 2.message Ensure that a scheduler is running on each client and ensure that the The IBM Storage group is no longer active.

You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. The IBM Storage group is no longer active. 4503501 Related Discussions TSM Error in Logs for Tivoli Storage Manager TSM Return Error Code 1909 TSM Scheduler fails to start in the In the logs you can see the following error.

ANS1312E (RC12) Server media mount not possible The weird thing is that you can see that there are some data that have been backed up before this error message. MS SQL Server MS SQL Server 2008 MS Server OS Orchestrating microservices on AWS for solution design – What’s next? For example, this code can occurs in SQL TDP agent. TDP exch sched fail 402 exchange MS mail Technote (troubleshooting) Problem(Abstract) The following errors may be seen in the dsmerror.log when attempting a Tivoli Data Protection for Microsoft Exchange schedule backup:

Privacy Policy Site Map Support Terms of Use Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business But there is no log found in TSM logs as to why this error occurred... 0 Question by:gkumar72 Facebook Twitter LinkedIn Google LVL 12 Best Solution bypastorchris Hi, The error code DMobley232 replied Oct 29, 2016 at 12:18 PM Help Understand Backup stgpool... Where do I find the explaination for these return codes ?

Also COMPRESSAlways is set to "YES" in opt file. First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. DMobley232 replied Oct 28, 2016 at 4:26 PM NDMP Restore of Old Data from... Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this