• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

sql server express backup schedule

I have a couple of sql server express editions. I want to schedule backups for database on them. Could you tell me how to do it.  Also if the backup fails I want to be notified by email.
2 Solutions
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
Two options
> visit lazycoding.com and download the free SQLScheduler
> visit ola.hallengren.com and download the scripts there.  They can be scheduled with the windows task manager.
Lee OsborneCommented:
You could create a scheduled task in WIndows to run a batch file with the following command line:

sqlcmd -E -S servername\sqlexpress –Q "BACKUP DATABASE [dbname] TO DISK='d:\dbname.bak' "

Just change the SQL instance and the dbname and location, and this should backup as expected.

Éric MoreauSenior .Net ConsultantCommented:
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.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now