<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
..shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:black;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
..MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:black'>This may be what you are looking
for:<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'><a
href="http://msdn.microsoft.com/en-us/library/ms186865.aspx">http://msdn.microsoft.com/en-us/library/ms186865.aspx</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:black'>I have scripts that run on my SQL
Express servers that use T-SQL to backup selected databases to a file. I
then use the file agent of my backup software to backup the database file to
storage. You may want to experiment with directing the backup file
destination to a network share to avoid another server license.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'><img border=0 width=131 height=63 id="Picture_x0020_1"
src="cid:image001.jpg@01CA522A.685D9CF0" alt=Sig></span><span style='font-family:
"Arial","sans-serif";color:black'><br>
<b>Paul Phillips</b><br>
IT Manager<br>
</span><a href="http://www.walkthru.org/" title="Walk Thru the Bible"><span
style='font-family:"Arial","sans-serif";color:black;text-decoration:none'><img
border=0 width=306 height=54 id="Picture_x0020_2"
src="cid:image002.png@01CA522A.685D9CF0"></span></a><span style='font-family:
"Arial","sans-serif";color:black'><br>
(678) 578-5535<br>
<a href="mailto:pphillips@walkthru.org"><span style='color:blue'>pphillips@walkthru.org</span></a><br>
<br>
<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
discuss-bounces@itdiscuss.org [mailto:discuss-bounces@itdiscuss.org] <b>On
Behalf Of </b>blloyd@buskercom.com<br>
<b>Sent:</b> Wednesday, October 21, 2009 7:41 AM<br>
<b>To:</b> discuss@itdiscuss.org<br>
<b>Subject:</b> [itdiscuss] SQL Express Backups<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<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?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p style='margin-bottom:12.0pt'><b><span style='font-size:14.0pt;color:navy'>Bill
Lloyd</span></b><span style='color:navy'> </span><span style='font-size:11.0pt;
color:navy'><br>
IT Manager</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><img
border=0 id="_x0000_i1025" src="cid:image003.jpg@01CA522A.685D9CF0"><o:p></o:p></span></p>
<p><span style='font-size:11.0pt;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><o:p></o:p></p>
<p><em><span style='font-size:11.0pt;color:navy'>blloyd@buskercom.com</span></em><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:7.0pt;font-family:"Arial","sans-serif";
color:navy'>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><o:p></o:p></p>
</div>
</body>
</html>