Restore MSSQL database on remote machine from backup file via C# code

Question

I have a mssql database on remote machine and backup file for this database. I want to create a method (c#) for restoring of database from backup. I will execute my method on my local machine. Can somebody help me to create such method for restoring remote database?

Where do you need to restore the DB?Showing us some code of what you've tried would also be helpful. — U r s u s
– U r s u s, Commented Aug 15, 2014 at 8:45

Bayeni · Accepted Answer · 2014-08-15 09:06:20Z

1

Try the this:

    public  void RestoreDatabase(string fileName)
    {
        try 
        {           
            using (SqlConnection conn = new SqlConnection("connectionString"))
            {
                string sql = "RESTORE DATABASE YourDatabase FROM DISK = N''" + fileName;
                conn.Open();
                SqlCommand _command = new SqlCommand(sql, conn);
                _command.ExecuteNonQuery();                
            }
        }
        catch (Exception ex)
        {
             throw;
        }
    }

You call it this way :

    RestoreDatabase(@"\\remotemachine\...\YourFile.bak");

NB: Put an actual path for where the file is located

answered Aug 15, 2014 at 9:06

Bayeni

1,0469 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Restore MSSQL database on remote machine from backup file via C# code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related