wHAT AM I DOING WRONG WITH MY RESTORE

Question

 I used the filelist command to get the logical names of my backup:

I then used the logical names to do the restore command. It is a brand new db that is on my ISP and I want to use it locally, so C:\MySQLServer doesn't exist. Where should I be restoring it to?

Answer 1

Below link address your issue exactly

http://blog.sqlauthority.com/2010/10/05/sql-server-error-fix-msg-5133-level-16-state-1-line-2-directory-lookup-for-the-file-failed-with-the-operating-system-error-2the-system-cannot-find-the-file-specified/

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 2

That doesn't help at all. I just need to know what the path is that I'm restoring to.

It's a brand new database locally. All I have is the backup

Answer 3

Can you verify that c:\MySqlServer exists ?

can you make sure that you run under windows authentication

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 4

No it does not exist - I need to know what to put for that path.

I don't have a sql server installation, just a backup! 

Answer 5

can you just create the folder

leave it empty then run the sql script again.

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 6

That worked, thank you!