question

sakuraime avatar image
0 Votes"
sakuraime asked TiborKaraszi commented

SQL backup : encryption + NO_COMPRESSION

Can I backup a database with encryption , while without COMPRESSION?

seems by default it helps me to compress , even I passed option NO_COMPRESSION.

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TiborKaraszi avatar image
0 Votes"
TiborKaraszi answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered TiborKaraszi commented

Hi sakuraime,
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

Best Regards,
Amelia


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

no.. it's also turn off in default.

0 Votes 0 ·

Did you see my reply? I asked a couple of question, which could help us to help you.

0 Votes 0 ·