Results 1 to 3 of 3
  1. #1
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default SQL TDP Backup Failing

    On on of our SQL servers (SQL Express) we are having intermitted backup issues and I think we have determined the reason, though I don't understand it. None of our other servers have this issue.

    When the backup fails, TSM TDP logs show this for each of the DBs that won't backup (normally it's all of them, except for the system DBs which are always ok).........

    ACO5422E Received the following from the MS SQL server:
    Specified cast is not valid. (HRESULT:0x80004002)
    Backup of SQL DB1 will not be attempted.

    The owners of this server sent me this info that they see during the backup......

    2012-03-02 03:05:23.60 spid51 Starting up database 'DB1'.
    2012-03-02 03:05:24.43 spid51 Recovery is writing a checkpoint in database 'DB1' (5). This is an informational message only. No user action is required.
    2012-03-02 03:05:24.56 spid51 Starting up database 'DB2'.
    2012-03-02 03:05:25.16 spid51 Starting up database 'DB3'.
    2012-03-02 03:05:26.33 spid51 Recovery is writing a checkpoint in database 'DB3' (9). This is an informational message only. No user action is required.
    2012-03-02 03:05:26.53 spid51 Starting up database 'DB4'.
    2012-03-02 03:05:27.49 spid51 Starting up database 'DB5'.

    When the backups work correctly, it's because they are already "started" and TSM TDP doesn't try to do that. They reboot the server every night, and after reboot, the SQL DBs are not "started."

    They are trying to figure out how to have the DBs started before the backup since it seems to be the reason that the backup fails.

    Has anyone dealt with this?

  2. #2
    Senior Member
    Join Date
    Jan 2010
    Location
    San Nicolas de los Garza NL
    Posts
    188
    Thanks
    0
    Thanked 10 Times in 10 Posts

    Default

    what´s your version TSM ?

  3. #3
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default

    TSM client 6.2.3.3.
    TSM SQL TDP 5.5.5.0.

    All SQL databases are set to "Auto_Close" = False

Similar Threads

  1. Replies: 5
    Last Post: 03-29-2012, 01:06 PM
  2. Replies: 0
    Last Post: 09-30-2011, 06:37 AM
  3. TDP SQL Backup failing
    By acamera in forum Microsoft SQL Server
    Replies: 3
    Last Post: 09-08-2010, 12:46 PM
  4. TDP SQL backup is failing
    By madbug0 in forum Microsoft SQL Server
    Replies: 13
    Last Post: 09-21-2009, 08:59 AM
  5. TDP SQL failing
    By nabildz in forum TDP/Application Layer Backup
    Replies: 7
    Last Post: 09-10-2009, 02:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •