Error creating SQL Server 2005 database with compressed disk

Asked

Viewed 423 times

2

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

TITLE: Microsoft SQL Server Management Studio Express

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476

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 PEDIDO.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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.5000&EvtSrc=MSSQLServer&EvtID=5118&LinkId=20476

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

sql-server-2005 database

  • Probably this path indicated does not have write permission, or the file .mdf is without permission. You have already checked?

  • I don’t know if This helps your problem, since there are 5 steps to be accomplished, try and say something.

  • I am as administrator, I have full permissions on the partition. Zuul unfortunately this does not solve my problem.

1 answer

0


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

MSDN

Browser other questions tagged sql-server-2005 database

You are not signed in. Login or sign up in order to post.