CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. July 23rd, 2003, 05:34 AM #1
    Blank
    Blank is offline Junior Member
    Join Date
    Jul 2003
    Posts
    3

    Lightbulb Want to restore database in SQL server remotely

    Hi,
    I have created an application, which restore the database using SQLDMO in SQL server at the local machine. Now if user provides the server name and username and password, then i want to access the SQL server at the LAN and restore the database at the SQL server. ....Can anybody help me ...Or knows some controls to be used to do this work.......or anybody who can help me.
    Thank you very much in advance
    Regards
    OK
    Reply With Quote Reply With Quote
  2. March 18th, 2004, 09:10 AM #2
    Valentin Rozescu
    Valentin Rozescu is offline Member
    Join Date
    Aug 1999
    Location
    Romania, Bucharest
    Posts
    253
    try to put in Files prop of Restore object the filename with the network path

    restoreobject.Files = "\\\\remotemachine\\restoreshare\\file"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured