How to restore Backup file from remote PC to SQL Server?

[Sachin Gedam]

Hello Friedns, I am tring to restore backup file which is on Machine1. And SQL server might be on anyother machine in local network. I am using this Code: ============================================================== //create an instance of a server class SQLDMO._SQLServer srv = new SQLDMO.SQLServerClass(); //connect to the server if(rbLocal.Checked==true) srv.Connect(this.txtServName.Text,this.txtUserName.Text,this.txtPass.Text); else srv.Connect(this.cmbServList.Text,this.txtUserName.Text,this.txtPass.Text); //create a restore class instance SQLDMO.Restore res = new SQLDMO.RestoreClass(); //set the backup device = files property ( easy way ) res.Devices = res.Files; //set the files property to the File Name text box res.Files = "[" + System.IO.Path.GetTempPath()+"AlcoMateBlank.BAK" + "]"; //set the database to the chosen database res.Database = this.txtDBName.Text; // Restore the database res.ReplaceDatabase = true; res.SQLRestore(srv); ============================================================== This code working properly if Backup file is on Local Machine but not if backup file is on another machine in a network. I am getting this error BackupDiskFile::OpenMedia: Backup device 'C:\DOCUME~1\sachin\LOCALS~1\Temp\AlcoMateBlank.BAK' failed to open. Operating system error = 3(The system cannot find the path specified.). Can you please suggest me eassy way of restoring database from remote PC to remote sql server which is in LAN? Sachin Gedam (Software Engg.) Pune India