Error: The file "*.mdf" or "*.ldf" is compressed but doesn't reside in a read-only drive (4222979)

Tchater maintenant avec le support

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

Error: The file "*.mdf" or "*.ldf" is compressed but doesn't reside in a read-only drive
Description

Error during restore:
Restore failed for Server '<servername>'. (Microsoft.SqlServer.Smo)
System.Data.SqlClient.SqlError: The file "e:\Db.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. (Microsoft.SqlServer.Smo)
Cause

In SQL Server 2000, you could create a new database with its mdf and ldf files located on a NTFS compressed drive.
With the release of SQL 2005, you can no longer create a read/write database on a compressed file system.
A read/write database’s primary .mdf and .ldf files cannot be created on a compressed drive. Log files should never be placed on compressed file systems. System database (master, msdb, model and tempdm) cannot be placed on compressed drives.
Résolution

WORKAROUND:
You can stop SQL Server service and then compress the data and log files of a read/write database. However, once you restart SQL Server, the read/write database will still be visible in your Management Studio, but if you try to access it, it will error. Uncompress the files and everything should go back to normal. Microsoft does NOT recommend that data or log files be hosted on compressed drives.
Informations supplémentaires

For more info, see; From Microsoft: http://blogs.msdn.com/b/sanchan/archive/2006/06/04/617585.aspx

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 4/9/2011
Dernière mise à jour le : 5/7/2023

Error: The file ".mdf" or ".ldf" is compressed but doesn't reside in a read-only drive (4222979)