sql express 2005 scheduled back up

kelehenry

I have my sql query working and it can back up my data base, still having a problem with getting the schedular to execute my query tried running the sqlcmd.exe file from the schedular but its not backing up my data base. pls help

Nov 5 '08 #1

ck9663

What's the error?

-- CK

Nov 5 '08 #2

kelehenry

Thanks for the help problem solved and have found an easier method of running the Query Ive created in SQLExpress. simply created a Bat file which ran the
SQL QUERY and used in my task schedule.
This is what the bat file contains
SQLCMD.EXE -S HENRY-PC\SQLEXPRESS -i "c:\SQLQuery2.sql"

Nov 5 '08 #3