• 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.
0
dedri
Asked:
dedri
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.
0
 
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.

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