Re: problem with restoring DB using vc++
From: Frank Hickman (fhickman_NOSP_at_M_noblesoft.com)
Date: 12/01/04
- Next message: venAdder: "Re: problem with restoring DB using vc++"
- Previous message: diamondgeo_at_diamondgeo.org: "Re: Data provider or other data servie returned an E_FAIL status"
- In reply to: venAdder: "problem with restoring DB using vc++"
- Next in thread: venAdder: "Re: problem with restoring DB using vc++"
- Reply: venAdder: "Re: problem with restoring DB using vc++"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 30 Nov 2004 22:35:07 -0500
The only problem I see is your using an administrative share and the
permissions cannot be altered. You have a couple of options that I can
think of trying.
1. Give the SQL Server account Administrative permissions on the workstation
(not really a great solution!).
2. Create a share and give the SQL Server account access to it.
-- ============ Frank Hickman NobleSoft, Inc. ============ Replace the _nosp@m_ with @ to reply. "venAdder" <venAdder@discussions.microsoft.com> wrote in message news:48D61BB9-5DE9-47DC-ABF4-4F0A95BB31E8@microsoft.com... > 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.
- Next message: venAdder: "Re: problem with restoring DB using vc++"
- Previous message: diamondgeo_at_diamondgeo.org: "Re: Data provider or other data servie returned an E_FAIL status"
- In reply to: venAdder: "problem with restoring DB using vc++"
- Next in thread: venAdder: "Re: problem with restoring DB using vc++"
- Reply: venAdder: "Re: problem with restoring DB using vc++"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
