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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Attaching difficulty of MDF db to SQL Server

Author  Topic 

Rejith
Starting Member

1 Post

Posted - 2010-03-17 : 01:20:04


One of our Hardware Technician had Changed the Drive letter [size=3]E to D of a HP Server (.net environment) where SQL Server 2005 is installed on a Windows platform.

He has reverted it to the same drive letter. (D to E)

Soon after this incident when a Programmer tried to attach a latest DB (mdf) into this server it gets attached and shows a Error "Read only" and we couldn't browse the Tables as we did in earlier sessions.

What would be the solution ?

Tell us a way to attach and browse the DB (Earlier there were several attached databases where we switched from one to another depending on the need DB for the application software)

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-03-17 : 09:45:54
he apparantly mounted it as a read only device. have him fix it
Go to Top of Page
   

- Advertisement -