how to using batch file database backup and Restore using in

Question

I am Create Visual Studio Web Application and i want to Know how to Create Local Database Restore Network Database Using C# Code Please Explain Step by Step

Mukesh · Answer

How to pass value in Function Parameters SqlConnectionStringBuilder csb, string destinationPath and i Want to Call on Button Click so Please Help me I am Calling on Button Click Like- [HttpPost] public ActionResult Index1() { return View(); }

Sreekanth Reddy · Answer

Hi Mukesh , Hi try the following, It might help you : public void BackupDatabase(SqlConnectionStringBuilder csb, string destinationPath) { ServerConnection connection = new ServerConnection(csb.DataSource, csb.UserID, csb.Password); Server sqlServer = new Server(connection); Backup bkpDatabase = new Backup(); bkpDatabase.Action = BackupActionType.Database; bkpDatabase.Database = csb.InitialCatalog; BackupDeviceItem bkpDevice = new BackupDeviceItem(destinationPath, DeviceType.File); bkpDatabase.Devices.Add(bkpDevice); bkpDatabase.SqlBackup(sqlServer); connection.Disconnect(); } public void RestoreDatabase(String databaseName, String backUpFile, String serverName, String userName, String password) { ServerConnection connection = new ServerConnection(serverName, userName, password); Server sqlServer = new Server(connection); Restore rstDatabase = new Restore(); rstDatabase.Action = RestoreActionType.Database; rstDatabase.Database = databaseName; BackupDeviceItem bkpDevice = new BackupDeviceItem(backUpFile, DeviceType.File); rstDatabase.Devices.Add(bkpDevice); rstDatabase.ReplaceDatabase = true; rstDatabase.SqlRestore(sqlServer); } Taken from the following URL : https://stackoverflow.com/questions/1466651/how-to-restore-a-database-from-c-sharp If it helps, Mark as answer. Thank you.