Microsoft SQL Server 2005 EXPRESS -- Automatic Backup ?

I currently open Microsoft SQL Server Management Studio Express, rightClick on the database I want to backup, and leftClick TASKS/BACKUP.

How can I get this to automatically run on my "Microsoft SQL Server 2005 EXPRESS" at 2pm daily ?
Who is Participating?
Anthony PerkinsConnect With a Mentor Commented:
Let me ask the same question I asked in your duplicated question here:

Assuming that LAPTOPSDL is local, what happens when you run the following from the command line:
sqlcmd -S LAPTOPSDL -E -i C:\backup\backup.sql
Aneesh RetnakaranDatabase AdministratorCommented:
unfortunately there is no sql server agent available on SQL Express , you have try the methods mentioned here
Raja Jegan RSQL Server DBA & ArchitectCommented:
finance_teacherAuthor Commented:
Attached are the steps and screenshots I did (on two different machines, both running their own MSSQL 2005 Express) based on, I waited for the task to finish, but nothing except my Backup.sql appeared in C:\Backup after doing a refresh.

1. How can I see what errored in the "Scheduled Task" ?
2. How can I get this to work ?
Raja Jegan RSQL Server DBA & ArchitectCommented:
You configured LAPTOPSDL\laptop user to configure Scheduled backups to run.

Does that user is part of Sysadmin and database admin privileges so that backup task can run successfully.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.