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?