A problem happend when i try to attach a database

  • Hello

    In SQL SERVER 2005,when i am trying to attach database files it happens an error the message is:

    "Database Northwind can not be upgraded because is it read only or has read only files make database or files writeable and rerun recovery "

    I checked and I have write access right to the folder with files and to the files itself , I am the administrator of the database what is wrong?

    Luis Martin

  • have network admin make certain that user permissions are not set to read only on drive

  • if you copy it directly from a CD - at times the RO flag is set on the file as well...

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • is not in network is a pc only ,nad i had copy from a cd but i see and have writeable permissions

    HELP ME PLEASE :crying:

  • Hi,

    Sorry, but I have to double check. Have you copied all db files from CD to your local pc? Have you checked file security properties after copying from cd to local drive?

    Thanks,

    Phillip Cox

  • Hi,

    Pls check RW privilege for SQL service startup account on both the files(i.e in file level also, goto file property and check) and also the folder where the files are existing.

  • did someone alter the original northwind database to be readonly ?

    perform on your sql2k :

    alter database northwind set read_write;

    Then stop the sql2000 instance or detatch northwind db, copy it to your sql2005 and attach it.

    or use backup / restore

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 7 posts - 1 through 6 (of 6 total)

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