How To Automate The Backup Of A SQL Server 2005 Express Data Store

Tuesday, 08 May 2007 by Michel Roth

With the coming of Presentation Server 4.0, it has become possible to have a MDSE (Microsoft SQL Desktop Engine) database as your Citrix Datastore. It's better than Access in many cases. But it's free so it's got to have some drawbacks right? Well it does. It doesn't come with much of any management tools by default. Seeing as you might want to backup your Citrix Datastore every once in a while you need to go the extra mile to automate such an backup. Koetie Koepke explains"

"I recently built a Presentation Server 4.5 (PS 4.5) farm where the decision was made to use a SQL Server 2005 Express database as the IMA data store. When it came time to create an automated backup of the data store, I soon realized the process was not at simple as creating a SQL job in a friendly GUI as with a full-blown SQL Server install, or running DSMAINT BACKUP. This article describes how automate the backup a SQL Server Express data store without having to purchase a third-party tool or without having to learn SQL programming. That said, this document is intended for the non-SQL savvy administrator unfamiliar with creating T-SQL statements."

Read the entire article at BrianMadden.com