sql express 2005 scheduled back up

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kelehenry
    New Member
    • Nov 2008
    • 5

    sql express 2005 scheduled back up

    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
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    What's the error?

    -- CK

    Comment

    • kelehenry
      New Member
      • Nov 2008
      • 5

      #3
      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.s ql"

      Comment

      Working...