How does xp_restore_verifyonly work with TSM?
exec master.dbo.xp_restore_verifyonly
@tsmobject = N'SQLSERVERBKP\SERVER\PRD - FULL',
@tsmconfigfile = N'C:\Backup\tsm.opt',
@tsmclientnode = N'mssql',
@tsmclientownerpwd = '********'
GO
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?
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center