25. June 2008 03:54
One of the limitations of SQL Server Express 2005 is that it doesn't have a built in way to schedule jobs. There are tools out there that let's you run jobs on the express version, but if you're like me who don't like to install a lot of things on your servers then you would try to avoid that route. I was in need of running scheduled back ups of my SQL Server Express databases, but I couldn't find a way to schedule them through any built in SQL Server functionality. A simple search yielded me to this excellent article which shows how to schedule backups through the use of SQL Server and Windows Scheduler. Stay tune for a future blog post to see my implementation of Scheduled Back Ups with SQL Server Express.