Restore restore = new Restore(); restore.Database = "bw_restore"; restore.Action = RestoreActionType.Database; restore.Devices.AddDevice(@"C:\SQLBackup\bw.bak",DeviceType.File); restore.ReplaceDatabase = true; restore.NoRecovery = false; restore.RelocateFiles.Add(new RelocateFile("bw",@"C:\SQLBackup\bw.mdf")); restore.RelocateFiles.Add(new RelocateFile("bw_Log",@"C:\SQLBackup\bw_Log.ldf")); ServerConnection connection = new ServerConnection(@"Data Source=NILE-ROSE\SQLEXPRESS;User ID=sa;Password=welcome@123;Initial Catalog=bw_restore;"); connection.LoginSecure = true; //connection.LoginSecure = false; //connection.Login = "testuser"; //connection.Password = "testuser"; Server sqlServer = new Server(connection); //MessageBox.Show(sqlServer.ToString()); restore.SqlRestore(sqlServer); MessageBox.Show("Restored Successfully");
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)