Backing up an SQL Express database

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!!
holcomb_frankAsked:
Who is Participating?
 
rlogCommented:
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
 
Aneesh RetnakaranDatabase AdministratorCommented:
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
 
Éric MoreauSenior .Net ConsultantCommented:
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
holcomb_frankAuthor Commented:
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
 
Éric MoreauSenior .Net ConsultantCommented:
express maint is working really great.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
How my comment is different than the accepted solution
0
 
Anthony PerkinsCommented:
I was just asking myself the same question.
0
 
holcomb_frankAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.