[SQL] Error forcing restore database?

WasteMan

Dedicated Member
Dedicated Member
Right - just changed computers, and setting up SQL Server again.... And i upload the DB and force restore of it.. then get this: -
SQLERROR.png


any help please.
thanks.
/gelex
 

Satchmo

Dedicated Member
Dedicated Member
Feb 16, 2004
84
6
105
Gods County
When restoring you will need to change the data location paths from lom2 to mir2 (in your case) On one of the screens in the import process you will clearly see these. If you're still having issues, i'll see if i can dig up some screenshots.
 
Upvote 0

Elvin

Golden Oldie
Golden Oldie
May 14, 2003
1,155
1
195
middlesex
is sql installed on C: , if it isnt then you will need to tell sql when u restore what drive its on, as you can see from ur image its trying to do something in c: drive but it may not be there.

sorry for my bad explanation but i cant really explain much about sql :P
 
Upvote 0

jasper

Golden Oldie
Golden Oldie
Sep 10, 2005
890
3
125
what satchmo said, u need to change the path or the name of the locations behind that error box
 
Upvote 0

Turin

Golden Oldie
Golden Oldie
Mar 21, 2004
590
0
123
LomCN
Best way to do that I expect is to navigate to the SQL directory using explorer, (via Local Disk -> Programs -> Microsoft SQL -> MSSQL -> Data or w/e), then just copy paste the directory from the address bar into the paths. Making the necessary amends of course.

Best be sure to be honest!
Turin
 
Upvote 0