<div>
No. &nbsp;You can set this at the server level, but then it applies to ALL dbs.<br />
<br />
USE master;<br />
EXEC sp_configure ‘backup compression default’, '1';<br />
RECONFIGURE WITH OVERRIDE;<br />
<br />
But that shouldn't be a big deal. &nbsp;Why don't you want the backups for some dbs compressed?
</div>


No.  You can set this at the server level, but then it applies to ALL dbs.

USE master;
EXEC sp_configure ‘backup compression default’, '1';
RECONFIGURE WITH OVERRIDE;

But that shouldn't be a big deal.  Why don't you want the backups for some dbs compressed?

<div>
ok.. hmm..<br />
<br />
one db is 400GB, other 120GB.. but both backups are almost same in size.. so I wondered if one alone could be compressed and other not .. I just wanted to check.
</div>


ok.. hmm..

one db is 400GB, other 120GB.. but both backups are almost same in size.. so I wondered if one alone could be compressed and other not .. I just wanted to check.

<div>
<div class="content wysiwyg-content">
is it possible to set that only certain databases will use the 2008 compression automatic option during backup? if so, where can we see this setting (system views)?
</div>
</div>


is it possible to set that only certain databases will use the 2008 compression automatic option during backup? if so, where can we see this setting (system views)?

compression option at database level instead of server level?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.