marcus72
asked on
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\Tes t.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?
the file "E:\MSSQL.1\MSSQL\DATA\Tes
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I would keep them on the C: drive.
ASKER
Thank you for your help.
ASKER