If a Windows job is required to backup and restore using LiteSpeed via command line, what is the correct syntax?
N/A
Use a command line similar this for backup:
sqllitespeedx32.exe -S"myservername" -Bdatabase -D"AdventureWorksAW" -C2 -n"AdventureWorksAW - Full Database Backup" -d"Full Backup of AdventureWorksAW on 12/9/2011 2:33:20 PM" -F"C:\Backup\%date:~10%-%date:~4,2%-%date:~7,2%-%time:~0,2%-%time:~3,2%-test.bak" -T
For restore, similar t this:
sqllitespeed.exe -R Database -D AdventureWorksAW -F "C:\Backup\%D.bak"
For additional examples, descriptions and syntax, see the LiteSpeed Help file.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center