Backing up an SQL Express database
Posted on 2013-05-28
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!!