SQL Server Performance

LiteSpeed backup status

Discussion in 'Third Party Tools' started by Raghu, Aug 22, 2009.

  1. Raghu New Member

    Hi,
    I use the below script to take litespeed backup and restore. Even though if i mention the STATS parameter i dont see the status during the backup or restore.
    do we have any other parameter that need to be used to view the status like SQL native backup STATS parameter.
    EXEC master.dbo.xp_restore_database @database='DatabaseName'
    , @filename = 'K:MSSQLBackupDatabasename_DB.BAK'
    , @With = 'Stats = 1'
    EXEC master.dbo.xp_Backup_database @database='DatabaseName'
    , @filename = 'K:MSSQLBackupDatabasename_DB.BAK'
    , @With = 'Stats = 1'
    thanks
  2. MohammedU New Member

    STATS option will not work with LiteSpeed but it supplies another extended procedure to see the status of backup/restore operation.
    xp_slsReadProgress @database = 'dbname'

Share This Page