How to execute a backup in a batch file, using LiteSpeed command utility.
Explanation for creating a batch file to run a backup job, using trusted windows authentication.
Use notepad to create the batch file, with appropriate field name for server | instance, and the destination of the backup file.
@Echo On
Set path=\\Program Files\Quest Software\LiteSpeed\SQL Server\Engine
sqllitespeed -T -Bdatabase -Sdomain\instance -Ddatabase_name -t3 -c1 -I1 -F\\testfolder\database_name.bak
PAUSE
Cls
-T for trusted
-S for server | instance connection
- default path for Litespeed versions lower than 5.x is \\Program Files\Imceda\LiteSpeed\SQL Server\Engine but it all depends on your installation directory.
