Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using R2 and compression
Message
From
26/07/2010 00:09:19
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Backups
Title:
Using R2 and compression
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01473850
Message ID:
01473850
Views:
141
On one specific server, under R2, the compression does not work. This command:
BACKUP DATABASE [LevelExtreme] TO DISK = 'D:\Data\Level Extreme\LevelExtreme.bak' with compression
GO
gives this:

Msg 3098, Level 16, State 2, Line 1
The backup cannot be performed because 'COMPRESSION' was requested after the media was formatted with an incompatible structure. To append to this media set, either omit 'COMPRESSION' or specify 'NO_COMPRESSION'. Alternatively, you can create a new media set by using WITH FORMAT in your BACKUP statement. If you use WITH FORMAT on an existing media set, all its backup sets will be overwritten.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

Is there an easy way to resolve that? When I tested that on two other PCs, it worked.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform