#

I always forget this so it is going in a blog for quick reference: SP_CONFIGURE 'show advanced options',1 RECONFIGURE WITH override GO

SP_CONFIGURE 'backup compression default',1
RECONFIGURE WITH override
GO </code>