Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using R2 and compression
Message
 
 
À
26/07/2010 00:09:19
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01473850
Message ID:
01473851
Vues:
27
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform