Bill,<div><br></div><div>Running maintenance on a SQL Server Express instance is not difficult, if you know your options. Basically, it amounts to running the backups using TSQL in stored procedures that are scheduled from a Windows Scheduled Job, since Express doesn't have the SQL Agent. (On a side note, if you do have a full version of SQL 2005 on another box, you can use it to run your maintenance tasks.)</div>
<div><br></div><div>Rather than stepping you through, here are a couple links that'll get you going:</div><div><br></div><div><a href="http://www.mssqltips.com/tip.asp?tip=1174">http://www.mssqltips.com/tip.asp?tip=1174</a></div>
<div><a href="http://www.mssqltips.com/tip.asp?tip=1174"></a><a href="http://www.sqldbatips.com/showarticle.asp?ID=27">http://www.sqldbatips.com/showarticle.asp?ID=27</a></div><div><br></div><div><a href="http://www.sqldbatips.com/showarticle.asp?ID=27"></a>On my servers, I run Ola Hallengren's maintenance scripts. They take care of finding all databases, backing them up, and running other tasks such as index defrag, checkdb, etc. I'm just throwing this link out there for anyone who's ready to go to that next level:</div>
<div><br></div><div><a href="http://ola.hallengren.com/">http://ola.hallengren.com/</a></div><div><br></div><div><a href="http://ola.hallengren.com/"></a>Jeremy Marx</div><div>DBA / Architect</div><div>Rhema Bible Church</div>
<div>Tulsa, OK</div><div><a href="http://twitter.com/jmarx">http://twitter.com/jmarx</a><br><br><div class="gmail_quote">2009/10/21 <span dir="ltr"><<a href="mailto:blloyd@buskercom.com">blloyd@buskercom.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal">I don’t know about you all, but I have a couple of
servers with business services that use MS SQL Express. For example,
Virtual Center and ScriptLogic both use SQL databases. I don’t have
enough SQL licenses in my backup software to back them up with a SQL
agent. What have you all done to backup your SQL Express databases?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks,</p>
<p class="MsoNormal"> </p>
</div>
<br><br><div align="left"><p><font face="Times New Roman"><span style="font-weight:bold;font-size:14pt;color:navy">Bill Lloyd</span></font><font color="navy"> </font><font face="Times New Roman"><span style="font-size:11pt;color:navy"><br>
IT Manager</span></font><br><br></p><img><br><p><font face="Times New Roman"><span style="font-size:11pt;color:black">2567 Athens Hwy.<br>Gainesville, GA 30507<br>Phone: 770-417-1604 Ext.: 250<br>Fax: 770-417-1747<br>
Cell: 404-379-6963</span></font></p><p><font face="Times New Roman"><span style="font-size:11pt;color:navy"><em><a href="mailto:blloyd@buskercom.com" target="_blank">blloyd@buskercom.com</a></em></span></font></p><p class="MsoNormal">
<span style="font-size:7pt;color:navy;font-family:Arial">This email and any accompanying attachments may contain confidential and proprietary information. If you are not the intended recipient, you are requested to delete this entire communication immediately. Emails cannot be guaranteed to be secure or free of errors or viruses. The sender does not accept any liability or responsibility for any problems that may result from emails you receive.</span></p>
</div></div>
<br>_______________________________________________<br>
it discuss mailing list: <a href="mailto:discuss@itdiscuss.org">discuss@itdiscuss.org</a><br>
Mailing List: <a href="http://itdiscuss.org/discuss" target="_blank">http://itdiscuss.org/discuss</a><br>
Internet Relay Chat: irc://<a href="http://irc.freenode.net/citrt" target="_blank">irc.freenode.net/citrt</a><br>
<br></blockquote></div><br></div>