Use the below script to verify the litespeed backup file
exec master.dbo.xp_restore_verifyonly
@filename = N'\\backups\full\mydbbackup.full.BAK',
@filenumber = 1,
@logging = 0
Advertisements
Use the below script to verify the litespeed backup file
exec master.dbo.xp_restore_verifyonly
@filename = N'\\backups\full\mydbbackup.full.BAK',
@filenumber = 1,
@logging = 0
Thanks a lot. Was very useful to check the integrity of backup files of light speed.
Hi,
how to get the full backup report of database .my enivoenmnet is configured with lite speed full.
You can query MSDB tables to get backup details.
Hi Jugal, My Litespeed restore script has use the lastest full backup file of date and time while restoring the database
instead of previous date and time.