TSM Backup for SQL says completed but No logs for completion

Posted on 2011-10-14
Last Modified: 2012-05-12
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...
Question by:gkumar72
    LVL 12

    Accepted Solution

    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.

    LVL 12

    Expert Comment

    Here are more resources about TSM TDP:

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
    This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
    This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now