FWIW, here's some code for automating the backup process in SQL Server Express: http://www.cfgears.com/index.cfm/2010/7/20/Automating-backups-for-SQL-Server-Express
Thanks, Eric Cobb http://www.cfgears.com Help me make a difference this summer -http://bit.ly/i8dJvQ On 5/11/2011 1:36 PM, Carl Von Stetten wrote: > While installing the trial of SQL Server 2008 will get you the full > Management Studio and Business Development Studio (or whatever it is > called in 2008, and is required for developing SSIS solutions), SQL > Server Express does not have the SSIS service. You have to have at > least one full SQL Server 2008 server somewhere to have an SSIS > service. You might consider purchasing SQL Server 2008 Developer > Edition (which should be about $50) which is essentially a fully > functioning version of SQL Server 2008 Enterprise with the licensing > restriction that it only be used for development and not production. > > Link to Developer Edition on MicrosoftStore.com: > http://www.microsoftstore.com/store/msstore/en_US/pd/productID.221634300/search.true > > HTH, > Carl > > On 5/11/2011 8:08 AM, Russ Michaels wrote: >> I'm sure I used SSIS with 2005 Express, so I would expect it is with 2008. >> You certainly have import/export services anyway. >> Just make sure you get SQL Server Express with Tools. >> If you find features missing from the Management Studio express, there is a >> little cheat, you can download the FULL EDITION trial of SQL Server 2008 >> with tools, and get the full edition of Management Studio, which i'm pretty >> sure never expires, at least it didn't with 2005. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344465 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
