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.

Thanks,
LVL 2
DowntownITAsked:
Who is Participating?
 
mittermuellerConnect With a Mentor Commented:
Why not user SQL internal backup (to file) feature (maintenance plan)?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please read this article on how to do it:http://www.sqldbatips.com/showarticle.asp?ID=27
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
mittermueller, "maintenance plan" is not available on Express Edition
0
 
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.
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.

All Courses

From novice to tech pro — start learning today.