public static void RestoreDB(string backUpFilePath, string databaseName) { try { Restore restore = new Restore(); restore.Database = databaseName; restore.Action = RestoreActionType.Database; restore.Devices.AddDevice(backUpFilePath, DeviceType.File); restore.ReplaceDatabase = true; restore.NoRecovery = false; restore.RelocateFiles.Add(new RelocateFile("DB_Jaggery", @"C:\Temp\DB_jaggry.mdf")); restore.RelocateFiles.Add(new RelocateFile("DB_Jaggery_log", @"C:\Temp\DB_Jaggry_log.ldf")); ServerConnection connection = new ServerConnection(@"SNEHA-PC\SQLEXPRESS"); Server sqlServer = new Server(connection); restore.SqlRestore(sqlServer); MessageBox.Show("Restore operation succeeded"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)