When running xp_viewcontents, information of backups created from other servers could not be retrieved.
e.g.
exec master.dbo.xp_view_tsmcontents
@tsmclientnode = 'ClientNode'
, @tsmclientownerpwd= '***'
, @tsmfilespace= 'LiteSpeed'
, @tsmconfigfile= 'C:\dsm.opt'
, @logging = 2
14:20:55.001 14964 Main TsmEnvironment::checkVersion calling dsmQueryApiVersionEx
14:20:55.001 14964 Main TsmEnvironment::checkVersion TSM API Library Version = 5.5.3.0 unicode
14:20:55.048 14964 Main TsmEnvironment::init dsmSetup ok
14:20:55.048 14964 Main TsmConnection::connect Doing sign on for node ClientNode
14:20:55.048 14964 Main TsmConnection::connect calling dsmInitEx
14:20:55.079 14964 Main TsmConnection::connect Connected to server version 5.4.4.0
14:20:55.079 14964 Main TsmConnection::connect Handle on return = 1
14:20:55.079 14964 Main TsmConnection::connect calling dsmQuerySessInfo
14:20:55.079 14964 Main TsmQuery::queryBackups malloc query.objName & query.owner
14:20:55.079 14964 Main TsmQuery::queryBackups calling dsmBeginQuery
14:20:55.079 14964 Main TsmQuery::queryBackups calling dsmGetNextQObj: 0
14:20:55.110 14964 Main TsmQuery::queryBackups dsmGetNextQObj error DSM_RC_UNKNOWN_FORMAT: Object skipped
14:20:55.110 14964 Main TsmQuery::queryBackups calling dsmGetNextQObj: 1
14:20:55.110 14964 Main TsmQuery::queryBackups dsmGetNextQObj error DSM_RC_UNKNOWN_FORMAT: Object skipped
…
…
14:20:58.632 14964 Main TsmQuery::queryBackups calling dsmGetNextQObj: 18583
14:20:58.632 14964 Main TsmQuery::queryBackups dsmGetNextQObj error DSM_RC_UNKNOWN_FORMAT: Object skipped
14:20:58.632 14964 Main TsmQuery::queryBackups calling dsmGetNextQObj: 18584
14:20:58.632 14964 Main TsmQuery::queryBackups dsmGetNextQObj error DSM_RC_UNKNOWN_FORMAT: Obj
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center