http://www.sqlservercentral.com/blogs/sqldbauk/2010/03/29/scheduling-backups-in-sql-server-express/

Printed 2014/11/28 01:50PM

Scheduling backups in SQL Server Express

By Gethyn Ellis, 2010/03/29

I have seen many forum posts asking how do you schedule backups for SQL Express databases and the answers always have similar responses that go something like:

“There is no SQL agent in Express…the only way to backup databases on a schedule is to write a script and call it from a batch file.”

I saw this recent Microsoft  knowledge base article and thought I would post a link to it here, it talks you through in detail how to schedule backups in SQL express using the above method:

http://support.microsoft.com/default.aspx?scid=kb;en-us;2019698&sd=rss&spid=2855


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.