January 25, 2010 at 1:41 am
Hi..
I am getting the following error message while try to access the database Test.
Database 'Test' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
i can able to access all other system and user databasae except Test database. All the database files are located in the same location only.
when i check the sql server error log its showing the following error messages
2010-01-25 12:51:41.030 spid51 Starting up database 'Test'.
2010-01-25 12:51:41.060 spid51 The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2010-01-25 12:51:41.110 spid51 The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test_log.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
Pls let me know how to resolve this issue.
Thanks in advance.
January 25, 2010 at 3:09 am
I think the error messages are very clear....
sudhakara (1/25/2010)
The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test_log.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
Database files cannot be encrypted or compressed. Decompress either the folder or the file.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply