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

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,
0
DowntownIT
Asked:
DowntownIT
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please read this article on how to do it:http://www.sqldbatips.com/showarticle.asp?ID=27
0
 
mittermuellerCommented:
Why not user SQL internal backup (to file) feature (maintenance plan)?
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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