SQL 2008 standard edition maintenance plans and compression comment..
A minor niggle with SQL standard edition and SSMS :-
I don't use SQL standard edition very often.. So this surprised me on SQL 2008 service pack 1 -
When creating a backup maintenance task, SSMS gives you the following options :-
See that you are allowed to select 'compress backup' - even though this feature is not supported in standard edition !
Running the maintenance task job will give error :-
the following error: "BACKUP DATABASE WITH COMPRESSION is not supported on Standard 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
Sorry Microsoft - but the maintenance plan GUI really shouldn't allow someone to select an unsupported option !
I wonder if this has changed in SQL 2008 R2 ?