SQL Server DBA, Developer, Architect, Author, Presenter
Tuesday, September 1, 2015
Is database backup compression enabled?
How do I check if database compression is already enabled?
select case when value = 1 then 'Yes' else 'No' end as [Backup Compression Enabled] from sys.configurations where name = 'backup compression default' ;
No comments:
Post a Comment