If someone can help. I just installed SQL Server 2005 Express. I am trying to attach a SQL Server 2000 database so I can work on it. I am getting the following error.
Msg 5118, Level 16, State 1, Line 1
The file "L:\SQL Data\Data\Dougins_Data.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'Dougins'. CREATE DATABASE is aborted.
I cannot find instructions in help to decompress the file. Does anyone have any suggestions?
I dont think so there is file compression is related to database. Check with your windows folks since file compression are done at the OS level. Ask them to decompress the files and you should be good to go.
No comments:
Post a Comment