[itdiscuss] SQL Express Backups

[blloyd at buskercom.com]

Do you use Windows scheduler to schedule the backup?

 

From: discuss-bounces at itdiscuss.org
[mailto:discuss-bounces at itdiscuss.org] On Behalf Of Phillips, Paul
Sent: Wednesday, October 21, 2009 8:42 AM
To: IT Discussion Forum
Subject: Re: [itdiscuss] SQL Express Backups

 

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

 

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.



Bill Lloyd
IT Manager

Busker Communications
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/ecc72402/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/ecc72402/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/ecc72402/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/ecc72402/attachment-0003.jpeg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bcilogo25.jpg
Type: image/jpeg
Size: 14873 bytes
Desc: not available
Url : http://optimus.thompsonic.com/pipermail/discuss/attachments/20091021/ecc72402/attachment-0001.jpg