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.
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.