Solved

Backup Sql Express

Posted on 2010-09-07
4
333 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

770 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