[itdiscuss] SQL Express Backups

[Phillips, Paul]

This may be what you are looking for:

http://msdn.microsoft.com/en-us/library/ms186865.aspx

 

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.

 

 
Paul Phillips
IT Manager
  <http://www.walkthru.org/> 
(678) 578-5535
pphillips at walkthru.org <mailto:pphillips at walkthru.org> 



 

From: discuss-bounces at itdiscuss.org
[mailto:discuss-bounces at itdiscuss.org] On Behalf Of blloyd at buskercom.com
Sent: Wednesday, October 21, 2009 7:41 AM
To: discuss at itdiscuss.org
Subject: [itdiscuss] SQL Express Backups

 

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?

 

Thanks,

 

 

Bill Lloyd 
IT Manager

 

2567 Athens Hwy.
Gainesville, GA 30507
Phone: 770-417-1604 Ext.: 250
Fax:     770-417-1747
Cell:     404-379-6963

blloyd at buskercom.com

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://optimus.thompsonic.com/pipermail/discuss/attachments/20091021/53166962/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 1664 bytes
Desc: image001.jpg
Url : http://optimus.thompsonic.com/pipermail/discuss/attachments/20091021/53166962/attachment-0002.jpeg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 12212 bytes
Desc: image002.png
Url : http://optimus.thompsonic.com/pipermail/discuss/attachments/20091021/53166962/attachment-0001.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 14873 bytes
Desc: image003.jpg
Url : http://optimus.thompsonic.com/pipermail/discuss/attachments/20091021/53166962/attachment-0003.jpeg