Restoring database always throwing exception I am trying to restore some database backup file into the same database. The .bak file is creating problem always. When I select the .bak file from a network drive like "\\TestPC\ShareFolder\test.bak" then its working correctly. 

But the same .bak file if I select from a local drive by copying it to my pc, say C:\TestPath\test.bak then for every time its throwing a exception saying 


  Cannot open backup device 'C:\TestPath\test.bak'. Operating system error 3(The system cannot find the path specified.).
  RESTORE DATABASE is terminating abnormally.


I don't know why its throwing, I also changed the SQL Server log on from a Network drive to a local connection also. Still its not working. Can some one hint me how to solve this problem?
If you want to restore a *.bak file onto a machine e.g. TESTSERVER, then that *.bak file needs to be 


on a local drive of TESTSERVER, or:
on a share in the network that TESTSERVER can reach (a "public" share)


So if you have the *.bak file on your local PC MyPC, you can try to do a restore from \\MyPC\C$\ShareFolder\Backupfile.bak and this might or might not work. 

But you cannot use C:\ShareFolder\Backupfile.bak since that will go to the server's C:\ drive and look for that file - and thus you get the error message and it cannot be found.

After all: your SQL Server instance is running on TESTSERVER - so if that process there executes a restore from the C:\ drive, that'll be the C:\ drive on that server machine - not your local PC! If that server process on TESTSERVER can reach your machine, then you might use the UNC path notation to your local disk - so that might work.