SQL Express management tool has limited functionality and it lacks the process of scheduling backups or any specific query tasks.
This particular example will execute a query and save it as *.csv file everyday.
//batch file start....
@echo off
set Today=%date:~10,4%%date:~4,2%%date:~7,2%
set Now=%time:~0,2%%time:~3,2%%time:~6,2%
sqlcmd -S localhost -d HistorianDB -E -Q "select recordnumber, name, timestamp, data from TrendLogView" -o "historianBkp-%Today%-%Now%.csv" -s"," -w600
cls
exit
//--end
Save this file with .batch extension and when executed creates a .csv file with datetime stamp. Now to automate this batch file execution you could use the windows scheduled task to do it.
