Problem
You get the following error messages when you try to backup all your databases in SQL Server Maintenance Plan.
Executing the query "BACKUP DATABASE [master] TO DISK = N'C:\\SQL1005_S..." failed with the following error:
"BACKUP DATABASE WITH COMPRESSION is not supported on Web Edition (64-bit).
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Solution
SQL Server 2008 Web Edition do not support compression with backup. We need to turn off the compression. Please follow these steps.
1) Open SQL Server Backup Database Task
Go to SQL Server Management Studio > Management > Management Plans. Open your maintenance plan with SQL Server backup database task.
2) Turn off compression for SQL Server backup
Choose Use the default server setting instead of Compress backup in the Set backup compression dropdown box.

Article ID: 155, Created: June 22, 2015 at 5:31 AM, Modified: September 3, 2015 at 10:24 AM