How to perform an unattended installation of SQL Server 2008 Express

A while ago I wrote an article called “How to perform an unattended installation of SQL Server 2005 Express“. With the release of SQL Server 2008 it’s time to write another one about how to do the same but for SQL Server 2008 Express. So, let’s get started …...

SQLCMD.EXE on SQL 2008 doesn’t work – HResult 0×2, Level 16, State 1

I’ve built one of my test servers with SQL Server Express 2008 w/ Advanced Services. On a whole load of our servers I use SQL Express for local installations and SQLCMD.EXE works well as a good way to run scheduled backups. It’s done this way because SQL Express doesn’t support SSIS (SQL Server Integration Services), the component required for scheduled tasks. I wrote an article about this a...