Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jooorj
Posting Yak Master
126 Posts |
 Posted - 2011-08-25 : 08:20:39
|
| How can I solve this problem ?"is compressed but does not reside in a read-only database or filegroup. The file must be decompressed."Thank youhttp://diwann.blogspot.com/ |
|
|
retrocat
Starting Member
2 Posts |
Posted - 2011-08-25 : 09:01:11
|
| It sounds like you're trying to restore to a compressed drive, which SQL doesn't allow. Check this link for details:http://blogs.msdn.com/b/sqlblog/archive/2006/10/02/sql-server-databases-are-not-supported-on-compressed-volumes.aspx |
 |
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-08-25 : 09:18:20
|
| please I still need help |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-25 : 09:23:33
|
| Did you click the link that retrocat provided? |
|
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-08-28 : 03:10:55
|
| That does not resolve my problem :(... |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-08-28 : 09:04:33
|
| Are you trying to restore the DB onto a compressed drive or folder?--Gail ShawSQL Server MVP |
|
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-09-06 : 05:17:27
|
| no , I am trying to restore directly on a normal drive also in c:\xzz\ it is not compressed , I use Win7plz I still need help. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-09-06 : 06:13:37
|
| Are you completely sure? Because that error is thrown when restoring a database to a compressed folder. Check the folder properties, make sure that compression isn't checked.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Problem in Restore DB SQL