Script to Verify the litespeed backup file

Written by

Jugal Shah

in

, ,

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

Comments

4 responses to “Script to Verify the litespeed backup file”

  1. Arun Avatar
    Arun

    Thanks a lot. Was very useful to check the integrity of backup files of light speed.

    Reply
  2. Samitha Avatar
    Samitha

    Hi,

    how to get the full backup report of database .my enivoenmnet is configured with lite speed full.

    Reply
    1. Jugal Shah Avatar
      Jugal Shah

      You can query MSDB tables to get backup details.

      Reply
  3. Naveen Avatar
    Naveen

    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.

    Reply

Thanks for the comment, will get back to you soon… Jugal Shah

More posts