problem with restoring DB using vc++

From: venAdder (venAdder_at_discussions.microsoft.com)
Date: 11/30/04

  • Next message: diamondgeo_at_diamondgeo.org: "Re: Data provider or other data servie returned an E_FAIL status" 
    Date: Tue, 30 Nov 2004 10:59:01 -0800

    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: diamondgeo_at_diamondgeo.org: "Re: Data provider or other data servie returned an E_FAIL status"

    Relevant Pages

    • Re: problem with restoring DB using VC++
      ... Server can be remote or local. ... > 2) I have a app which allows user to back up and restore mydb. ... > 4)this location could be on the server or the machine running the app. ...
      (microsoft.public.vc.database)
    • problem with restoring DB using VC++
      ... The Sql server has database mydb. ... I have a app which allows user to back up and restore mydb. ...
      (microsoft.public.vc.database)
    • Re: T-SQL CLOSE Connection to DB
      ... The 'MyDb' is still under the status RUNNABLE for the command 'SELECT ... INTO' under the ProgamName 'Microsoft SQL Server Management Studio - ... Management Studio uses the ALTER DATABASE command I ... paste the contents of the clipboard in a query window or in a ...
      (comp.databases.ms-sqlserver)
    • Re: Datenquelle variabel gestalten
      ... Beim Programmstart einfach testen, ob der in der app.config angegebene ... Server erreicht werden kann mit einem PseudoStatement. ... Entwicklungsumgebung mit MyDB und myServer ...
      (microsoft.public.de.german.entwickler.dotnet.csharp)
    • Pure performance after restoring to different server
      ... When I restore our production database that run very well to the ... front end app to access the database. ... The server itself hardware-wise is identical to the production one. ...
      (microsoft.public.sqlserver.server)
    Loading