The database backup prob with SQL Express can be worked around by calling a standalone script. For example:

This will backup a database by week day to C:\DbBackups via sqlcmd with Windows auth. And also be configured to a Windows scheduled task

sqlcmd -E -i backupdb.sql

DECLARE @BackupPath VARCHAR(255) SET @BackupPath = 'C:\DbBackups\'

DECLARE @Today CHAR(10) SET @Today = CONVERT(CHAR(10), GETDATE(), 126)

DECLARE @DayOfWeek VARCHAR(10) SET @DayOfWeek = DATENAME(WEEKDAY, GETDATE())

IF @DayOfWeek = 'Monday' BEGIN SET @BackupPath = @BackupPath + 'Monday\' END ELSE IF @DayOfWeek = 'Tuesday' BEGIN SET @BackupPath = @BackupPath + 'Tuesday\' END ELSE IF @DayOfWeek = 'Wednesday' BEGIN SET @BackupPath = @BackupPath + 'Wednesday\' END ELSE IF @DayOfWeek = 'Thursday' BEGIN SET @BackupPath = @BackupPath + 'Thursday\' END ELSE IF @DayOfWeek = 'Friday' BEGIN SET @BackupPath = @BackupPath + 'Friday\' END ELSE IF @DayOfWeek = 'Saturday' BEGIN SET @BackupPath = @BackupPath + 'Saturday\' END ELSE IF @DayOfWeek = 'Sunday' BEGIN SET @BackupPath = @BackupPath + 'Sunday\' END

DECLARE @BackupFile VARCHAR(255) SET @BackupFile = @BackupPath + 'mydatabase_' + @Today + '.bak'

BACKUP DATABASE [Mydatabase] TO DISK = @BackupFile WITH INIT, SKIP, NOFORMAT, NAME = N'mydatabase-Full Database Backup', STATS = 10