[itdiscuss] SQL Express Backups

[Jeremy Marx]

Bill,

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.)

Rather than stepping you through, here are a couple links that'll get you
going:

http://www.mssqltips.com/tip.asp?tip=1174
 <http://www.mssqltips.com/tip.asp?tip=1174>
http://www.sqldbatips.com/showarticle.asp?ID=27

<http://www.sqldbatips.com/showarticle.asp?ID=27>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:

http://ola.hallengren.com/

<http://ola.hallengren.com/>Jeremy Marx
DBA / Architect
Rhema Bible Church
Tulsa, OK
http://twitter.com/jmarx

2009/10/21 <blloyd at buskercom.com>

>  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.
>
> _______________________________________________
> it discuss mailing list: discuss at itdiscuss.org
> Mailing List: http://itdiscuss.org/discuss
> Internet Relay Chat: irc://irc.freenode.net/citrt
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://optimus.thompsonic.com/pipermail/discuss/attachments/20091021/808a436b/attachment.htm