CODEWITHSUNDEEP
sql-serverssms
daisy
daisy

Reputation: 23541

Where can I configure "the default server setting"?

I've created a SQLServer Maintenance Task with SMSS. In the "Back Up Database Task", there's an option to compress the database.

One of the is to "Use the default server setting".

enter image description here

On some servers the default setting is to compress the backup, some are not. Where do I get the value of the default compression setting?

Upvotes: 2

Views: 131

Answers (1)

RBarryYoung
RBarryYoung

Reputation: 56745

Pinal Dave has excellent tutorials on this here:

From SSMS you can set it by:

  1. right-click a server in the Object Explorer and select Properties.
  2. Click the Database settings node.
  3. Click the Compress backup box.

enter image description here

You can also set it from TSQL with the following commands:

USE MASTER;
GO
EXEC sp_configure 'backup compression default', 1;
RECONFIGURE WITH OVERRIDE;
GO

Upvotes: 3

Related Questions