Results 1 to 3 of 3
Thread: SQL TDP Backup Failing
03-05-2012, 01:26 PM #1
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?
03-05-2012, 05:39 PM #2
- Join Date
- Jan 2010
- San Nicolas de los Garza NL
- Thanked 3 Times in 3 Posts
what´s your version TSM ?
03-07-2012, 12:30 PM #3
TSM client 184.108.40.206.
TSM SQL TDP 220.127.116.11.
All SQL databases are set to "Auto_Close" = False
By collinsk in forum ScriptingReplies: 5Last Post: 03-29-2012, 01:06 PM
By collinsk in forum TSM OperationReplies: 0Last Post: 09-30-2011, 06:37 AM
By acamera in forum Microsoft SQL ServerReplies: 3Last Post: 09-08-2010, 12:46 PM
By madbug0 in forum Microsoft SQL ServerReplies: 13Last Post: 09-21-2009, 08:59 AM
By nabildz in forum TDP/Application Layer BackupReplies: 7Last Post: 09-10-2009, 02:28 PM