On 9 Mar 2010 at 16:03, Kurt Buff wrote: > Well, one further limitation: SQL Express doesn't (at least didn't, > this may have changed) have a backup/dump/data deletion/truncate > utility that comes with - one has to be written. This has actually > bitten at least one product I know of.
FWIW http://www.google.com/search?q="sql+express"+backup 1st hit: How do you backup a database using sql server 2005 express??? http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/95750bdf-fcb1-45bf-9247-d7c0e1b9c8d2 You're not quite right here, SQL Express fully supports backing up a database. What it does not have is SQL Agent, which allows you to schedule backups and the Mataintenance Plan wizard which allows you to create a plan to perform a number of tasks, including backup. You can backup your database in two ways: 1. Use Management Studio Express (available separately or as part of Express advanced from this download page) which has the Backup option on the right click menu for each database under Tasks. 2. Use T-SQL to manually write your backup script. You can learn about the T-SQL backup command in this BOL topic. If you want to schedule your backups, you would write a T-SQL script and then use Windows Task Schedule to call SQLCmd to run the script on what every schedule you're interested in. Regards, Mike Wachal SQL Express team 2nd hit: Automating Database maintenance in SQL 2005 Express Edition Part I http://www.sqldbatips.com/showarticle.asp?ID=27 In this series of articles, I'll demonstrate a couple of different approaches to writing a maintenance utility that mimics some of the behavior of the sqlmaint utility that is included with SQL Server 2000. SQL Server 2005 Express Edition does not include such a utility, so these articles will show how we can easily create one ourselves using either TSQL or SMO (SQL Management Objects - the successor to SQL-DMO). Rather than dive into the code, these articles will demonstrate how to use these utilities for backing up and maintaining your databases and how to schedule these tasks using the Scheduled Tasks facility in Windows XP and Windows 2003. In this article we will concentrate on the TSQL version of the utility which is in the form of a stored procedure - expressmaint. To download a command line version built using SMO go to Automating Database maintenance in SQL 2005 Express Edition Part II. To vew articles on performing maintenance operations using SMO including sample code see the Related Articles section at the bottom of the page. -- Angus Scott-Fleming GeoApps, Tucson, Arizona 1-520-290-5038 Security Blog: http://geoapps.com/ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
