Backup Sql Express

We have several Sql Servers Standards (2005) and one instance of Express. I have one database on the express that I need to backup on a regular schedule. Is there a way that I can do this from SSMS (Standard)? Either through a Maintenance plan or scheduled job? I would prefer not to use Windows Task Schedule.

Who is Participating?
mittermuellerConnect With a Mentor Commented:
Why not user SQL internal backup (to file) feature (maintenance plan)?
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please read this article on how to do it:
Guy Hengel [angelIII / a3]Billing EngineerCommented:
mittermueller, "maintenance plan" is not available on Express Edition
DowntownITAuthor Commented:
Because that is what I want to do and I just an idiot not to notice the "Manage Connections" that allows me to connect to my Sql Express.

Thanks for making me take a second look.
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.