Solved

Backup Sql Express

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

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 143

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

679 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