Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using R2 and compression
Message
 
 
To
26/07/2010 00:09:19
General information
Forum:
Microsoft SQL Server
Category:
Backups
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01473850
Message ID:
01473851
Views:
26
>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.

In the options dialog don't chose append, chose overwrite.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform