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/
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.
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..
Resolving the problem Increase the Max Mount Points Allowed (UPDATE NODE
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
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.
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:
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