November 8, 2007 at 6:14 pm
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
November 8, 2007 at 6:28 pm
have network admin make certain that user permissions are not set to read only on drive
November 8, 2007 at 7:49 pm
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?
November 8, 2007 at 8:00 pm
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:
November 9, 2007 at 3:44 am
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
November 10, 2007 at 1:56 am
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.
Regards..Vidhya Sagar
SQL-Articles
November 10, 2007 at 3:50 am
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