Post reply

READ ONLY database

  • 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

  • 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

  • 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]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply