Attach DB from storage drive

Hi, this will probably sound like a noob question.  But I have a server running windows 2003 and I've installed SQL 2005.  On the server I have 70gb on the 'C' drive and 500gb on the 'E' or storage drive.  I've copied a couple of DB's onto the storage drive and would like to attach them to the SQL instance on the 'C' drive.  However, when I go through the management studio object explorer and right click on 'databases' and attach the database .mdf file stored on the 'E' drive I receive the following error:

the file "E:\MSSQL.1\MSSQL\DATA\Test.mdf" is compressed but does not reside in a read-only database or filegroup.  The file must be decompressed.
Could not open new database 'Test'.  CREATE DATABASE is aborted (Microsoft SQL Server, Error 5118)

Is it even possible to store a database on a drive separate to where SQL is installed?
marcus72Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sbagireddiConnect With a Mentor Commented:

If you are an SA, go to disk management and unclick "compress disk to save space" for the drive that had the .mdf you are trying to attach.
0
 
marcus72Author Commented:
Thank you sbagireddi, that worked.  Should I leave the admin databases like Master.mdf / msdb.mdf / mssqlsystemresource.mdf on the 'C' drive or can I attach them from the storage drive?
0
 
sbagireddiCommented:
I would keep them on the C: drive.
0
 
marcus72Author Commented:
Thank you for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.