how to using batch file database backup and Restore using in

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mukesh7y ago
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 Reddy7y ago
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.