• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2316
  • Last Modified:

TSM Backup for SQL says completed but No logs for completion

In Cluster setup, when taking SQL Database backup using TDP SQL, we are getting error ANR2579E with Return code 402. But there is no log found in TSM logs as to why this error occurred...
0
gkumar72
Asked:
gkumar72
  • 2
1 Solution
 
Chris MConsulting - Technology ServicesCommented:
Hi,
The error code 402 is for the following message:
"The process is already in background processing mode."

Are you trying to command a new backup when you get this error?
If yes, than I suspect that the previous backup process is either hanging or incomplete when you issue the current backup command.

You might want to deal with that process at OS level before you continue attempt to issue a the next backup command.

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 SQL backups are) instead of trying to use shadow copy backup method with TDP.

Windows shadow copy of the SQL database files will complete but if your databases are quite volatile, you may get an inconsistent image that you may not be able to use upon restoring from your backups on your storage manager.

Therefore do not configure TDP to backup SQL database files directly.

All the best.

0
 
Chris MConsulting - Technology ServicesCommented:
Here are more resources about TSM TDP: http://www.lascon.co.uk/d005005.htm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now