Restore Database

Question

am writing code to restore sql database in c#.i have tried many ways even though am getting error.plz help

Bharathi Raja · Answer

Microsoft.SqlServer.Management.Smo.Server smoServer = new Server(new ServerConnection(server)); Database db = smoServer.Databases[ 'MyDataBase' ]; string dbPath = Path.Combine(db.PrimaryFilePath, 'MyDataBase.mdf' ); string logPath = Path.Combine(db.PrimaryFilePath, 'MyDataBase_Log.ldf' ); Restore restore = new Restore(); BackupDeviceItem deviceItem = new BackupDeviceItem( 'd:\MyDATA.BAK' , DeviceType.File); restore.Devices. Add (deviceItem); restore. Database = backupDatabaseTo; restore.FileNumber = restoreFileNumber; restore. Action = RestoreActionType. Database ; restore.ReplaceDatabase = true ; restore.SqlRestore(smoServer); db = smoServer.Databases[ 'MyDataBase' ]; db.SetOnline(); smoServer.Refresh(); db.Refresh();

Avikshith Aradhya · Answer

You can refer below link, http://www.c-sharpcorner.com/UploadFile/rohatash/restore-sql-server-backup-file-with-C-Sharp/ http://www.codeproject.com/Tips/873677/SQL-Server-Database-Backup-and-Restore-in-Csharp

Vasanth Natarajan · Answer

Hi., Try The links http://www.c-sharpcorner.com/UploadFile/rohatash/restore-sql-server-backup-file-with-C-Sharp/ http://www.codeproject.com/Tips/873677/SQL-Server-Database-Backup-and-Restore-in-Csharp http://stackoverflow.com/questions/4218960/how-to-restore-sql-server-database-through-c-sharp-code