Hi,

I have this scenerio:-

1) The Sql server has database mydb. Server can be remote or local. The problem is when it's remote so will mention only that case(remote means on LAN ).

2) I have a app which allows user to back up and restore mydb.

3) If the user wants to restorte the Db he is shown windows common file open dialog box, the user selects the file from some location and hit open.

4)this location could be on the server or the machine running the app. Now if the file is on server everything goes well, but if the file is on the machine running the app SQL Server comes back with the error saying device error of device offline.

The restore is doen by using a stored proc on the database which basically executes somehiting like
restore datatbase mydb from disk = '\\machinename\driveletter$\......\mydbbkp.dat'

Now I imagine this could be due to the fact that the server might not have access to the machine running the app. Is there a way to overcome this hurdle??

Please help!! Have worked too long on all this to be stuck at this thing.

Thanks