Sql Server restore/backup database from remote client programmatically

Question

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?

thanks Boomer! it just uses typical sharing folder. I want to do it programmatically without changing all client OS settings. — H. Aghassi
– H. Aghassi, Commented Jun 27, 2012 at 5:51
You cannot restore a remote backup - the *.bak file has to be on the machine you're restoring to - either directly on a local disk, or on a network share that machine has access to. — marc_s
– marc_s, Commented Jun 27, 2012 at 6:23

H. Aghassi · Accepted Answer · 2012-06-27 14:48:53Z

6

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.

answered Jun 27, 2012 at 14:48

H. Aghassi

2314 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dennis · Accepted Answer · 2012-06-27 05:58:43Z

2

Make a share on the server. Then, copy backups there from the client machine, if you want to restore database, or copy backups to the client machine from there, if you want to store backup at the client.
Of course, client must have r/w permissions for this share.

answered Jun 27, 2012 at 5:58

Dennis

37.9k11 gold badges87 silver badges158 bronze badges

Comments

Rajesh Subramanian · Accepted Answer · 2012-06-27 05:56:25Z

0

Just an idea.

While Taking backup, Just store the backup file name and location in database table. So that you can show it to the user for recovery.

Still you can use database code restore with dynamic backup location argument.

answered Jun 27, 2012 at 5:56

Rajesh Subramanian

6,4855 gold badges33 silver badges42 bronze badges

Collectives™ on Stack Overflow

Sql Server restore/backup database from remote client programmatically

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related