Sql Server restore/backup database from remote client programmatically

c# sql-server backup database-restore
H. Aghassi picture H. Aghassi · Jun 27, 2012 · Viewed 7.3k times · Source

I want to backup and restore my database that is in the server from my client Desktop application in C#. I already found some sample code that do backup/restore programmatically, however it backups on the server computer and restores just from the server computer. The users should be able to select the backup files from client by the client application or create backup files in the client computers.

How can I do backup/restore remotely?

Answer

H. Aghassi picture H. Aghassi · Jun 27, 2012

I found a very useful method to backup remotely: http://www.codeproject.com/Articles/33963/Transferring-backup-files-from-a-remote-SQL-Server. However, the problem still exist for restoring remotely.

Related questions

How to restore a database from C#

I have a SQL 2008 DB. I am running a form that backs that DB up, then tries to update it. If the update fails the idea is to restore that backup. Here is the code I am using to restore …

Read More
How to execute a stored procedure within C# program

I want to execute this stored procedure from a C# program. I have written the following stored procedure in a SqlServer query window and saved it as stored1: use master go create procedure dbo.test as DECLARE @command as varchar(1000), @…

Read More
How can I set an SQL Server connection string?

I'm developing a simple C# application, and I'd like to know this: When I connect my application to SQL Server on my PC, I know the connection string (server name, password, etc.), but when I connect it to another PC, …

Read More