Need Help Decyphering TDPSql.log

jt-65

Newcomer
Joined
Apr 16, 2015
Messages
4
Reaction score
0
Points
0
PREDATAR Control23

Bear with me. I'm a SQL guy, not really a TSM guy, but somehow, this became my problem.

I'm doing VSS backups of SQL2008 databases. They're working, mostly. I had an issue; it's been resolved, but it shed light on the fact that I'm not clear on what's going on.

Below are some example lines from TDPSql.log - just so we'll have a common reference.

04/16/2015 09:44:29 ------------------------------------------------------------
04/16/2015 09:51:55 Snapshot operation completed with return code = 0.
04/16/2015 09:51:56 The following database is being backed up: 'DB1'. The data is being transferred to the Tivoli Storage Manager server.
04/16/2015 09:52:27 The following database is being backed up: 'DB2'. The data is being transferred to the Tivoli Storage Manager server.
04/16/2015 10:28:34 The following database is being backed up: 'DB3'. The data is being transferred to the Tivoli Storage Manager server.

Here are my questions about TDPSql.log and the backup process:
1. What happened between 09:44:29 & 09:51:55? Have all of the appropriate databases been shapshot(ted) and stored locally?
2. If so, are the following steps the local snapshots being transferred to the Tivoli server?
3. If so, am I reading it correctly that the transfer of DB1 took 31 seconds, while the transfer of DB2 took 36:07?
4. What on Earth order are these databases backed up? It seems to be random. Drives me crazy.
 
PREDATAR Control23

The time between 09:44:29 and 09:51:55 is when TSM is doing its work - looking at the databases and preparing for snapshot.

The rest is a marker when it is writing the snapshot to the backup media.

The order? TSM tries to do this sequentially as much as possible. If the 'source' is busy or resources are not available to complete a timely backup, it skips a source and goes to the next. Don't look for order as TSM will work on what it thinks it can do faster.
 
PREDATAR Control23

Thank you! That is a big help?

Is there a way to add more detail to this log?
 
Top