READ ONLY database

• scott clemons

  Mr or Mrs. 500

  Points: 550

  More actions

  May 4, 2008 at 3:43 pm

  #185085

  I just installed SQL Server 2005 Express on my home computer. I detached two databases from work - also running in SQL 2005 Express - brought them home and attached them. They are now READ ONLY. They were not READ ONLY at work.

  How do I make them NOT READ ONLY? Can this be done after already attaching them or should I detach and do it again with some options I am not aware of?

  Thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  May 4, 2008 at 3:56 pm

  #810484

  Are the files read only? (if you copied them using CD/DVD it's very likely they are)

  Are the files in a compressed or encrypted directory?

  What happens if you run

  ALTER DATABASE <Database name> SET READ_WRITE

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  May 5, 2008 at 10:10 am

  #810794

  Open SSMS

  Expand the list of databases

  Right click on a database name

  Left click on "Properties" in the menu which appears

  In the next window (left pane titled "Select a page")

  Click on "Options"

  Now in the right pane scroll down to "State"

  Changed the entry on the line titled "Database Read-Only" Click on "True" in the right column, Select "False" from the drop down list

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]