is there any fix for this post, i'm having the same issue ?

thx for your response , i was intending to do that but i would like to have a fix on this too.

is there any fix for that ?

i agree with you but i'have already ask for space but it's going to take time on client side. i need to do something now.

maybe, as you requested, i'll change...

KareM ,thx for your response but i cant either do that manually because there are lot of big indexes.it's not going to help me really.

the problem is the log file size , i dont have enough space available for 20 or 25 gb because my log is always around 1GB. i can't leave it...

the developer does not want to change his connection string or program at every change, that's why he was requested this.if the name of the server changes, he would be...

it's a request.but just to make sure that it's still not possible

thx guys

thx for your response.since i dont know what fonctionalité gonna be using in the futur, i would prefer entreprise.

thx

i can confirm that the issue was definitely Sercurity. the third party application was locking the file.

i stopped it and it works.

thx for your support

thx for this detail.you probably right, i notice yesterday that third party application was locking the file , i tried to rename and i see the error message for locking,...

i,ve checked the Sql service account, it the same windows admin account which is running SQL. he got full access to everything on the server.

i've tested it with the Admin right locally on the server, that database being attached succesfully is still on read only status, but i succeded to attached the rest of...

the path are correct and the mdf,ldf,ndf file are in read write mode .the second option, i'll may be tested it the the Win administrator account which is supposed to...

yes i can confirm that the paths are correct because i even browsed in sql to select the correct file. i was thinkinf of mdf file, those files have been...

here is the command

ALTER DATABASE r123

SET READ_WRITE

*****************************************

here is the full erro message :

Msg 5105, Niveau 16, État 4, Ligne 1

Device activation error. The physical file name 'G:\data_prod\rd_prod1.mdf' may be incorrect.

Msg 5105, Niveau 16, État 4, Ligne 1

Device activation...