Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Backing up an SQL Express database

Posted on 2013-05-28
9
Medium Priority
?
259 Views
Last Modified: 2013-09-25
we have a new app on our server that runs as a database - we have SQL express 2005 running an instance for this database to work. our backup software was provided by our vendor and it's a little different then what I'm used to seeing but works fine except for this new change. we need to stop the instance of sql so that we can run our backup and then start it up again before the new day starts. i have read about scripts and a few different suggestions. we are looking for an easy recommendation for doing this.  This is a propriatary application so things I read about modifying the database or configuration of it are not something we can do. We need to stop the agent, and start the agent for sql express. I have read about using Microsoft SQL Studio express, but i'm concerned that installing that will affect the current configuration done by our vendor.

we have a windows server 2008 box. we are using a program called OBE2.0 to back up our two primary programs on this server now.

any suggestions are greatly appreciated!!
0
Comment
Question by:holcomb_frank
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +2
9 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 39202422
the best option is to use the windows scheduled tasks for this  as mentioned here

http://www.mssqltips.com/sqlservertip/1174/scheduling-backups-for-sql-server-2005-express/

Also there are some free tools which can be used for this purpose
0
 
LVL 4

Accepted Solution

by:
rlog earned 2000 total points
ID: 39202465
SQL Express doesn't have an agent (comes with workgroup edition or higher). You can setup jobs in windows scheduler via the osql utility. You can take manual backups via Mgmt Studio Express I believe. Please do so of all databases (master,model, msdb, application db) manually.

Microsoft has created a good solution HERE. This is the most common way of running backups of Express edition.

So once you've managed to do this please try to restore on a different server.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 39204113
0
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.

 

Author Comment

by:holcomb_frank
ID: 39242815
we are still trying the suggestions and it's not working for us....we haven't abandoned it.... but it's still work in process
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 39243038
express maint is working really great.
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 39518205
How my comment is different than the accepted solution
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39518511
I was just asking myself the same question.
0
 

Author Comment

by:holcomb_frank
ID: 39520337
we gave points to the one that we could get the closest to work... honestly we had trouble with all solutions. If as a moderator you want to change the points....please do. I have never had this issue with the forum before.....  split the points with everyone if you like.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

688 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