SQL Server Performance

The backup cannot be performed because 'COMPRESSION' was requested after the media was formatted with an incompatible structure.

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Oct 10, 2010.

  1. Anonymous New Member

    This is a new error associated to BACKUP related issues and to be specific first time on this environment. There was no setting of BACKUP COMPRESSION enabled on the SQL 2008 instance which is used by a 24/7 application, by default after the installation backup compression is off. The default behavior for backup compression is defined by the backup compression default Option server-level configuration option. See the below code which can be used to create the compressed backups on that instance irrespective...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2010/10/11/the-backup-cannot-be-performed-because-compression-was-requested-after-the-media-was-formatted-with-an-incompatible-structure.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9649" width="1" height="1">

Share This Page