Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.6 - Configure Log Shipping Guide

LiteSpeed Variables

LiteSpeed Variables

LiteSpeed automatically substitutes variables anywhere you need to specify a backup file name, comment, or description in the LiteSpeed UI Console, from the command-line and when using extended stored procedures.

ALL variables are supported for both files and folders.

ClosedClick here for information about the command-line and extended stored procedure arguments that accept LiteSpeed variables.

Accepted Variables

LiteSpeed accepts the following variables:



%DATABASENAME% or %D Database name
%TYPE% or %T Backup type (full, diff, log, fast compression folder)
%SERVER% Server name
%INSTANCE% Server instance name
%DEFAULTDIR% Default backup directory
%AG% AlwaysOn Availability Group name

Timestamp, the number of seconds elapsed since 00:00:00 January 1, 1970, UCT. See Note1.

Date and time variables


Date. See Note1.


Time (hhmm). See Note1.


Date and time. See Note1.


Abbreviated weekday name. See Note1.


Full weekday name. See Note1.


Abbreviated month name. See Note1.


Full month name. See Note1.


Day of the month (01-31). See Note1.


Hour in 24h format (00-23). See Note1.


Hour in 12h format (01-12). See Note1.


Day of the year (001-366). See Note1.


Month as a decimal number. See Note1.


Minute (00-59). See Note1.


AM or PM designation. See Note1.


Second (00-59). See Note1.


Week number with the first Sunday as the first day of week one (00-53). See Note1.


Weekday as a decimal number with Sunday as 0 (0-6). See Note1.


Week number with the first Monday as the first day of week one (00-53). See Note1.


Year, last two digits (00-99). See Note1.


Year. See Note1.


Time zone name or abbreviation.


Note1: Not supported for Fast Compression.


  1. Specify backup destination:


  2. Back up the Northwind database with the specified backup set name and description.

    EXEC master.dbo.xp_backup_database
    , @filename='C:\MSSQL\Backup\%D.BAK'
    , @init= 1
    , @backupname = '%D_%w'
    , @desc = '%T Backup of %D'

  3. Restore the Northwind database from the backup device c:\temp\Northwind.bak from the command-line interface.

    sqllitespeed.exe -R Database -D Northwind -F "C:\temp\%D.bak" -W REPLACE


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating