i have a sql express 2005 database which was created on another server.i want to restore that database to my sql server standard 2005 but i have so far have been unsuccessful. i tried the GUI restore option it failed so i followed the query guide from this website
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=40841[
^]
followed the instructions but still could not restore my database..
here is the Query
RESTORE FILELISTONLY
FROM DISK = 'E:\bari\latestDtNEt\millat_tractors_LTD.bak'
result
millat_tractors C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD.mdf D PRIMARY 41943040 35184372080640 1 0 0 88142C8F-19A6-4013-86C0-84970A84B80E 0 0 41287680 512 1 NULL 20000000034100037 34F0C4FF-F9D0-467D-B9AF-652CA99F2C70 0 1
millat_tractors_log C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD_1.ldf L NULL 48758784 2199023255552 2 0 0 D9911775-121F-4B01-A7C0-21EABDF234B2 0 0 0 512 0 NULL 0 00000000-0000-0000-0000-000000000000 0 1
restore query
RESTORE DATABASE millat_tractors_LTD
FROM DISK = 'E:\bari\latestDtNEt\millat_tractors_LTD.bak'
WITH REPLACE, MOVE 'millat_tractors' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD.mdf',
MOVE 'millat_tractors_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD_1.ldf'
and this the error i got
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD.mdf" failed with the operating system error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'millat_tractors' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD_1.ldf" failed with the operating system error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'millat_tractors_log' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD_1.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
thankyou