Return
-
Title
Is it possible to perform a differential backup using the command line utility? -
Description
Using the command line interface for LiteSpeed how are Differential backups performed? There is an option to do it using the Backup Database Wizard but is it possible to do with the command line interface?
-
Resolution
Differential backup of a database can be initiated using the LiteSpeed command line interface. The '–W differential' command is required to perform a differential backup via the command line.
Example:
Sqllitespeed.exe –B database –T –S server -D dbname –F file.bkp –W differential -
Additional Information
To create Differential backup by script:
declare exec master.dbo.xp_backup_database
@database = N'Northwind',
@filename = N'D:\Backup\Northwind200806090913LiteSpeed_Diff.BKP',
@backupname = N'Northwind backup',
@desc = N'Backup of Northwind on 2008-06-09 09:13:29',
@with = N'DIFFERENTIAL',
@with = N'SKIP',
@with = N'STATS = 10'