Restoring a database in another server using DMO

• brbalaji

  Newbie

  Points: 1

  More actions

  February 6, 2002 at 10:33 am

  #170417

  I have a database backup file in one machine and want to restore the same database in a another machine using DMO.

  Is there any way other than copying this backup file to second machine and then restoring?

  I need this functionality during installation where the user can select any sql server in the network.

  As I may not be having the permission to copy the backup file in the user selected machine, I have to execute the restore command from the machine in which application is installed.

  Any help would be greatly appreciated.

  Thanks in advance.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  February 6, 2002 at 11:19 am

  #423317

  If its just for an install why not use attach instead of restore? You'll still have to copy the file to whereever it belongs, regardless of method.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter