MCITP

MCITP

Thursday, March 10, 2011

Backup file contents

exec xp_objectrecovery_viewcontents
@FileName = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Payroll_201004111708.bak',
@FileNumber = 1,
@Type = 'All'

2 comments:

  1. Hi,

    I need to recover all the objects below schema, could you please tell me if my script is correct?

    exec xp_objectrecovery_viewcontents
    @FileName = N'd:\F_LS_IDUSDVS01_201211172202.BAK',
    @FileNumber = 1,
    @ObjectName = N'VMIMJWI.*',
    @DestinationDatabase = N'IDUSDVS01'

    Thanks
    Xty

    ReplyDelete