EXEC master.dbo.xp_restore_headeronly
@filename='D:Backup?0Northwind_200901220652.bak',
@filenumber=1
EXEC master.dbo.xp_restore_verifyonly
@filename = '\servernameBackup?0Northwind_200901220652.bak'
, @filenumber=1
, @encryptionkey = 'password'
NOTE: xp_restore_headeronly does not require that the password be supplied.
xp_restore_headeronly and xp_restore_verifyonly will verify files created on the same or earlier versions of LiteSpeed, but they will not verify files created on a later (higher) version. These xps will also work for files created/verified in SQL2000 and/or SQL2005
The output for the first query is described in the Help file of LiteSpeed.
The output for the second query:
The backup set on file 1 is valid.
CPU Seconds: ###
Environment: Intel(R) Pentium(R) 4 CPU 3.20GHz
CPUs: 2 logical, 1 core, 1 physical package.
The above description applies to AES128 level of encryption.
