Error creating database in SQL Server 2005 with compressed disk

Question

Error creating database in SQL Server 2005 with compressed disk

Navigation

#1 by (0 votes)

2

When I try to create a database, the following error occurs:

TITLE: Microsoft SQL Server Management Studio Express

Create failed for Database 'baseded'. (Microsoft.SqlServer.Express.Smo)

For help, click: link

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
     The file "C: \ Program Files \ Microsoft SQL Server \ MSSQL.2 \ MSSQL \ DATA \ REQUEST.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.   CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5118)

For help, click:

This happens because the disks are compressed, is there no way to create the database without decompressing the disks?

sql-server-2005

asked by anonymous 05.03.2014 / 13:39

1 answer

Problems with character that comes in NDefMessage NFC Change JavaScript code for resized video tag [closed]

score 0 · Accepted Answer

In addition to not being considered a good practice (Disk IO can be heavy on a database, requiring compression / decompression all the time) SSMS is not willing to create this .MDF unless you mark your BD filegroups actually) as read-only (which in this case will be .NDF).

MSDN