Automating the Backup of SQL Server Express 2005 and 2008

A great article with a tool you can use to automate backups of SQL Server 2005 and 2008 Express databases from the command prompt.

http://www.sqldbatips.com/showarticle.asp?id=29

The ExpressMaint utility supports the following operations

• Full Database Backup
• Differential Database Backup
• Log Backup
• Housekeeping of backup files
• Database Integrity Checks
• Database Index Rebuilds
• Database Index Reorganization
• Database Statistics Update
• Report Creation

SQL Server 2008 - Can't Save Changes to Table

For those who tested the new SQL Server 2008, you probably got this message, when trying to change the columns in some tables, add columns or change nullity conditions. "Save is not permitted"... and something like tables have to be dropped and re-created. The only choice you have is to click cancel, or to choose to save the message to a text file, which is, i think, not very useful.

The solution i found today is in SQL Books Online, nd it is pretty easy:

Tools -> Options -> Designers, and uncheck the option "Prevent saving changes that require table re-creation".