Trying To Attach New Files

[Spherixx]

Hey, i'm trying to update from Ep3 Files to Ep4 but I have 2 problems.. one with the guide and one is just an error i cant seem to fix.

If anyone knows what I may be doing wrong could you please tell me

Problem 1:
The guide i was using says if you don't want to keep Ep3 files then delete them but when i delete them i am no longer connected to my DB and cannot attach the new ones. Also trying to attach them while the old files are still there I get an error that tells me i cannot attach a file with the same name as an existing one.

Problem 2:
When I attempt to attach ones that do not have the same name i get this error, my friend and i thought upgrading to SQL Server 2008 would fix it, the server still runs fine on 2008 but it didn't help the error.

[Alladrios]

Make sure to close PSM processes before attaching new database

[[GM]Father]

Launch SQL Server Management Studio as an admin. (Right Click, Run As Adminstrator)

[Spherixx]

I have every time i try, I still get the same error.

Launch SQL Server Management Studio as an admin. (Right Click, Run As Adminstrator)

going to try that

Doesn't help. I still get kicked out after I delete the old files :|

[[GM]Father]

Rename or remove the old ones first. If you can't do that make sure you are running as admin and the services are not currently on. (ps_dbAgent, ps_game, ps_gameLog, ps_login, ps_session, ps_userLog, PSM_AgentClient, PSM_AgentServer)

Sometimes rebooting will free up services that are stuck.

[Spherixx]

They weren't on and i tried to re-name them but got an error, maybe i'm not checking correctly to see if they are running? how should I do this (correctly)

[[GM]Father]

Oh sorry, I meant to specify that. Right click the task bar and select Start Task Manager. Click on the Services tab and scroll down to your services.

It sounds like there is an uncommon problem happening for you. Try rebooting, verifying the services are off, then rename or remove the databases.

If this keeps happening, you should research the error on google/bing.

[Danco1990]

I had this problem a few days ago when putting a backup on my spare testserver. It is quite easy to fix, just go the the folder where you got your databases. riightclick the DB folder, properties, permission/security and in here give full read/write permissions to your useraccount, administrators, and if you have it, the SQL user. this will grant permissions.

[Spherixx]

THANK YOU Earth and Danco both of your fixes worked on both of my problems. but i have 1 more that just arrived, when i attempt to re name PS_GameDefs, i get this error.

[[GM]Father]

From your error, it looks like the database you were trying to rename was busy or being used.

[Spherixx]

I have no clue how to stop it then i don't exactly know where or what to look for, i came to that conclusion also :\

[[GM]Father]

Originally Posted by EarthCrush

...
make sure you are running as admin and the services are not currently on. (ps_dbAgent, ps_game, ps_gameLog, ps_login, ps_session, ps_userLog, PSM_AgentClient, PSM_AgentServer)

Sometimes rebooting will free up services that are stuck.

Try these steps.

As a precaution, make sure you don't have any edit windows open.

I don't know what the exact problem is, but doing these should be a 'blanket' solution.

[Spherixx]

I think this is what i'm looking for as far as seeing if they are running i'm not totally sure though...

[[GM]Father]

You can look in the tool, but it is better to look in Task Manager.
Xs mean that it is not installed. So, the services shouldn't be giving you a problem here.

You are still unable to rename?

Try shutting down MSSQLSERVER from Task Manager and restarting it.

[Spherixx]

Doesn't work, when i restarted it i still got the error when i tried to re name it, and thats the file or database that when i delete i get disconnected and cant re connect

EDIT: What would it be called when looking in Services ?