SQL Server BACKUP DATABASE is terminating abnormally: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Problem

You get the following error messages when you try to backup all your datbases 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.

Related Resources

Navigator

Other Knowledgebase Articles

Basic SQL Hosting

# of Domains: 4
# of SQL Server Databases: 4
Disk Space: 50GB
Bandwidth: Unmetered
SQL Server 2014
Monthly: $4.99
More Information About Basic Shared SQL Server Hosting Plan

Express Hyper-V Hosting

Dedicated Memory:2GB
Disk Space: 100GB
Bandwidth: Unmetered
Windows 2012/2008: Free
Monthly: $11.99
More Information About Express Windows Hyper-V Server

Dedicated SQL Server

CPU: Quad-Core X3440 CPU
RAM: 16GB RAM
Disk: 2x120GB SSD + 300GB SATA
RAID: RAID 1
Bandwidth: Unmetered
Windows 2012/2008: Free
Monthly: $79.00
More Information About Dedicated SQL Server with SSD
SQL Server Hosting | ASP.NET Hosting | DotNetNuke Hosting | Windows VPS Hosting | Dedicated Windows Server Hosting