SQL Server 2008 R2 SP3 Patch Failure

I was working on a SQL Server SP3 patch upgrade on Windows Server 2008 SP2 and for a server it failed with the following error.

 

 

"Attributes do not match. Present attributes (Directory, Compressed) , included attributes (0), excluded attributes (Compressed, Encrypted)"

Exit code (Decimal): -2068578304

Exit facility code:       1204

 

 

Solution

Go to C:\Program files\SQLServer\ and change the properties of this folder by unchecking

compress option/Archiving option.

 

 

 

 

Once you uncheck this, Re-ran the patch installation and it should complete successfully. It worked for me without any issues and hope does the same for all.

 

Njoy and Have a Gr8 Day!!