How Do i Backup and Restore a LocalDataBase? in c# Win App.

Question

i am looking for backup and resotre local database in c# window application.
i unable to find the root directory from where i have to resotre databse(mdf file). after making the exe of file.
Please somebody Help...

Rajkiran Swain · Answer

Microsoft.SqlServer.Smo Microsoft.SqlServer.SmoExtended Microsoft.SqlServer.ConnectionInfo Microsoft.SqlServer.Management.Sdk.Sfc Microsoft.SqlServer.SqlEnum string ServerName = server ; string DatabaseName = database; string UserId = userId; string Password = password; ServerConnection serverConnection; private Server _server; public Server Server { get { if (_server == null ) { Connect(); } return _server; } } string connectionString { get { return string .Format( Data Source={0};Initial Catalog={1};UID={2};Password={3}  ServerName DatabaseName UserId Password); } } public void Connect() { _serverConnection = new ServerConnection(); _serverConnection.LoginSecure = false ; _serverConnection.Login = UserId; _serverConnection.Password = Password; _server = new Server(_serverConnection); } public void BackupDatabase() { using (SqlConnection cn = new SqlConnection(connectionString)) { ServerConnection svCon = new ServerConnection(cn); Server svr = new Server(svCon); cn.Open(); cn.ChangeDatabase( master ); string testFolder = @ C:	emp ; string databaseName = _databaseName; Backup backup = new Backup(); backup.Action = BackupActionType.Database; backup.Database = databaseName; backup.Incremental = false ; backup.Initialize = true ; backup.LogTruncation = BackupTruncateLogType.Truncate; string fileName = string .Format( {0}\{1}.bak  testFolder databaseName); BackupDeviceItem backupItemDevice = new BackupDeviceItem(fileName DeviceType.File); backup.Devices.Add(backupItemDevice); backup.PercentCompleteNotification = 10; //backup.PercentComplete += backup_PercentComplete; //backup.Complete += backup_Complete; backup.SqlBackup(svr); if (!VerifyBackup(svr)) { //throw new Exception(Backup could not be verified.); } svr = null ; cn.Close(); } } public bool VerifyBackup(Server svr) { string testFolder = @ C:	emp ; string databaseName = _databaseName; Restore restore = new Restore(); restore.Action = RestoreActionType.Database; string fileName = string .Format( {0}\{1}.bak  testFolder databaseName); BackupDeviceItem backupItemDevice = new BackupDeviceItem(fileName DeviceType.File); restore.Devices.AddDevice(fileName DeviceType.File); restore.Database = databaseName; restore.PercentCompleteNotification = 10; //restore.PercentComplete += new PercentCompleteEventHandler(ProgressEventHandler); bool verified = restore.SqlVerify(svr); return verified; } public void RestoreDatabase() { using (SqlConnection cn = new SqlConnection(connectionString)) { ServerConnection svCon = new ServerConnection(cn); Server svr = new Server(svCon); cn.Open(); cn.ChangeDatabase( master ); string testFolder = @ C:	emp ; string databaseName = _databaseName; Restore restore = new Restore(); restore.Action = RestoreActionType.Database; string fileName = string .Format( {0}\{1}.bak  testFolder databaseName); BackupDeviceItem backupItemDevice = new BackupDeviceItem(fileName DeviceType.File); restore.Devices.AddDevice(fileName DeviceType.File); restore.Database = databaseName; restore.ReplaceDatabase = true ; restore.PercentCompleteNotification = 10; //restore.PercentComplete += new PercentCompleteEventHandler(ProgressEventHandler); svr.KillAllProcesses(databaseName); restore.SqlRestore(svr); svr = null ; cn.Close(); } }

aman deep · Answer

Dear Nilesh Shah Sir. actully i dont want to share Source Code. But If You Like To Help Me. I would like you contact you personly on mobile. If You Dont Mind Give Me Your Contact Number and Give me a time when we can talk...

Amit Gupta · Answer

Hey You can run sql script for taking backup/restore the database. https://www.mssqltips.com/sqlservertutorial/20/sql-server-backup-database-command/ https://www.mssqltips.com/sqlservertutorial/110/how-to-restore-a-sql-server-backup/

Nilesh Shah · Answer

Hi aman deep can you post the code/project as zip file? so that we understand what you have done till now? and suggest some ammendments to your code instead of suggesting something totally new?

Mani Kandan · Answer

Just prefer this: https://stackoverflow.com/questions/40691243/c-sharp-how-to-copy-sqlite-db-from-one-path-and-paste-it-to-another-path

Manikandan Murugesan · Answer

Refer the following Link : https://social.msdn.microsoft.com/Forums/vstudio/en-US/914d7230-f661-412c-8b22-55b7bd380da0/how-to-backup-and-restore-using-c-in-windows-application?forum=csharpgeneral