Solved

Backup Sql Express

Posted on 2010-09-07
4
331 Views
Last Modified: 2012-05-10
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
Comment
Question by:DowntownIT
  • 2
4 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 33619992
please read this article on how to do it:http://www.sqldbatips.com/showarticle.asp?ID=27
0
 
LVL 5

Accepted Solution

by:
mittermueller earned 500 total points
ID: 33620024
Why not user SQL internal backup (to file) feature (maintenance plan)?
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 33620070
mittermueller, "maintenance plan" is not available on Express Edition
0
 
LVL 2

Author Closing Comment

by:DowntownIT
ID: 33620090
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 Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now