Can I backup a database with encryption , while without COMPRESSION?
seems by default it helps me to compress , even I passed option NO_COMPRESSION.
How did you determine that it is compressed? Did you look at the output from RESTORE HEADERONLY, the Compressed column? If not, please do and let us know.
In addition, you can set the backup compression default server configuration to 0 to make sure the backup is not compressed. Please check this doc.
EXEC sys.sp_configure N'backup compression default', 0 GO RECONFIGURE WITH OVERRIDE GO
16 people are following this question.