|
|
|
Rank: Newbie
Groups: Registered
Joined: 5/9/2012
Posts: 1
|
Can someone please help me to solve this message
---
Directory lookup for the file "c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\nnnnn_12SEPT11_Data.mdf" failed with the operating system error 3(The system cannot find the path specified.).
File 'nnnnn_12SEPT11_Data' cannot be restored to 'c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\nnnnn_12SEPT11_Data.mdf'. Use WITH MOVE to identify a valid location for the file.
Directory lookup for the file "c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\nnnnn_12SEPT11_1_Data.ndf" failed with the operating system error 3(The system cannot find the path specified.).
File 'nnnnn_12SEPT11_1_Data' cannot be restored to 'c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\nnnnn_12SEPT11_1_Data.ndf'. Use WITH MOVE to identify a valid location for the file.
Directory lookup for the file "c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\nnnnn_12SEPT11_Log.ldf" failed with the operating system error 3(The system cannot find the path specified.).
File 'nnnnn_12SEPT11_Log' cannot be restored to 'c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\nnnnn_12SEPT11_Log.ldf'. Use WITH MOVE to identify a valid location for the file.
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
RESTORE DATABASE is terminating abnormally.
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 433
|
Hi,
Please check if exists directory "c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA".
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 6/17/2012
Posts: 3
|
I've got the same problem. I have my LIVE Server with Drive E and ow I am restoring the Full Db BAckup to a Test Server with Drive:\C only. Any fix on this issue? jporpilla attached the following image(s):
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 417
|
Your question is not specific to our product. As the message says, you need to use "WITH MOVE" along with your restore command. Or you can use One-Click SQL Restore (installed by default along with SQLBackupAndFTP) - it will do it for you
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 6/17/2012
Posts: 3
|
I am using One-Click Restore and it is giving me this issue. Any help?
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 433
|
Hi, One-Click Restore is a very simple application for general using. Please use any advanced tool like SQL Server Management Studio if you need some options and One-Click Restore does'n have them.
|
|
|
|
|
