Restore Database

Question

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

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

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();

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

AI Agents Conference 2026

Top earners

Our Training Programs

AI & Machine Learning

Mastering Large Language Models

Mastering Prompt Engineering

Certified Vibe Coder

Github Copilot Training

Generative AI for Beginners

n8n Automation & AI Agents Training

Restore Database

3 Replies