CODEWITHSUNDEEP
sql-serversql-server-2005
venkat
venkat

Reputation: 13

Directory look up for .mdf failed with operation system error 3 (the system cant find the specified path(microsoft.sqlServer.Express.smo)

I have taken SQL backup(.bak) from Windows server 2003 machine and trying to restore in Windows 7. when i am trying to do i have "Directory look up for .mdf failed with operation system error 3 (the system cant find the specified path(microsoft.sqlServer.Express.smo)" message.

I understand that it's trying to find out the path '.MDF' which is not available in this machine (Windows 7). so how i can restore this database.

Upvotes: 0

Views: 13563

Answers (2)

Jānis Konošonoks
Jānis Konošonoks

Reputation: 341

This manual available also HERE

Perform backup restore using T-SQL:

RESTORE DATABASE LNE FROM DISK = 'C:\LNE-22012016.bak'
WITH MOVE 'LNE' TO 'C:\SQL_data\LNE.mdf',
MOVE 'LNE_log' TO 'C:\SQL_data\LNE.ldf';

enter image description here

Upvotes: 3

Raj
Raj

Reputation: 10853

In the restore dialog, go to options and change the path of the file under Restore As to a valid path.

enter image description here

Upvotes: 2

Related Questions