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.
Click here for information about the command-line and extended stored procedure arguments that accept LiteSpeed variables.
XP argument | CMD argument | Description |
---|---|---|
@filename | -F | File name or stripe file name |
@mirror | -E | Mirror file name |
@backupname | -n | Backup name |
@desc | -d | Backup description |
@comment | -Y | Comment |
LiteSpeed accepts the following variables:
Variable |
Description |
---|---|
%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 |
%z |
Timestamp, the number of seconds elapsed since 00:00:00 January 1, 1970, UCT. See Note1. |
Date and time variables | |
%DATE% |
Date. See Note1. |
%TIME% |
Time (hhmm). See Note1. |
%DATETIME% |
Date and time. See Note1. |
%a |
Abbreviated weekday name. See Note1. |
%A |
Full weekday name. See Note1. |
%b |
Abbreviated month name. See Note1. |
%B |
Full month name. See Note1. |
%d |
Day of the month (01-31). See Note1. |
%H |
Hour in 24h format (00-23). See Note1. |
%I |
Hour in 12h format (01-12). See Note1. |
%j |
Day of the year (001-366). See Note1. |
%m |
Month as a decimal number. See Note1. |
%M |
Minute (00-59). See Note1. |
%p |
AM or PM designation. See Note1. |
%S |
Second (00-59). See Note1. |
%U |
Week number with the first Sunday as the first day of week one (00-53). See Note1. |
%w |
Weekday as a decimal number with Sunday as 0 (0-6). See Note1. |
%W |
Week number with the first Monday as the first day of week one (00-53). See Note1. |
%y |
Year, last two digits (00-99). See Note1. |
%Y |
Year. See Note1. |
%Z |
Time zone name or abbreviation. |
|
Note1: Not supported for Fast Compression. |
Specify backup destination:
\\Storage\Backup\%SERVER%\%DATABASENAME%_%TYPE%_%DATETIME%.bak
Back up the Northwind database with the specified backup set name and description.
EXEC master.dbo.xp_backup_database
@database='MyDB'
, @filename='C:\MSSQL\Backup\%D.BAK'
, @init= 1
, @backupname = '%D_%w'
, @desc = '%T Backup of %D'
sqllitespeed.exe -R Database -D Northwind -F "C:\temp\%D.bak" -W REPLACE
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center