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

Chatta subito con l'assistenza

Restituisci

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Titolo

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

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)
Causa

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.
Risoluzione

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.
Informazioni aggiuntive

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

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Contenuti consigliati

Cronologia articoli:: Data di creazione: 4/9/2011
Ultimo aggiornamento: 5/7/2023

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