How does xp_restore_verifyonly work with TSM?
@tsmobject = N'SQLSERVERBKP\SERVER\PRD - FULL',
@tsmconfigfile = N'C:\Backup\tsm.opt',
@tsmclientnode = N'mssql',
@tsmclientownerpwd = '********'
In this case, there are multiple PRD - FULL objects created everyday a new FULL backup is take. So when the xp_restore_verifyonly executes, which backup set will it validate? Is it configured to validate the latest by default?
Also, what would happen if a wrong tsmpointintime value is given to the restore procedure?