September 6, 2005 at 11:52 am
Does anyone know the reason why I am getting 5105 error when I try to attach a adatabase on a different server? I dettached the database from on server, copied the files to another SQL server and attached the database to the new server. SQL Server put the dettached database into a 'Read-Only' mode. When I tried to put it out of 'Read Only' mode, I received an error: 5105 Device activation error: The physical name ... may be incorrect. Could not start the database ...., revierting back to old status.
Thank you,
Nelson.
September 6, 2005 at 3:34 pm
1. Are the data and log files in the same filepath (including drive letter) as they were on the previous server? If not, you will need to list each file and its datapath.
sp_attach_db @dbname = 'database1'
,@filename1 = 'd:\database1_data.mdf'
,@filename2 = 'd:\database1_log.ldf'
Michelle
September 7, 2005 at 6:32 am
Thank you Michelle.
Nelson.
I have tried putting them in the same folder, sometimes it works other databases I still have the same problem. Sometimes when I copy instaed of moving the data it works, other times it doesn't.
September 8, 2005 at 5:01 pm
Hope the folder path exists, also the folder+path name does not have spaces within it; I remember somebody pointing it in the past
Also, try having them on some other drives / server and see if you get the same error, if not, then it is problem with your drive or machine
paul
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply