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?