A problem happend when i try to attach a database

Question

Post reply

A problem happend when i try to attach a database

luis martin ortiz barrutia

SSC Enthusiast

Points: 189
More actions
November 8, 2007 at 6:14 pm

#153949

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

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

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

russell-154600 Ten Centuries Points: 1375 More actions · Answer 1

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

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 2

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?

luis martin ortiz barrutia SSC Enthusiast Points: 189 More actions · Answer 3

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:

Big Data Man SSCrazy Eights Points: 8536 More actions · Answer 4

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

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 5

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

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 6

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