backup and restore db sql from C#

Question

Good, I work on my application to perform backups and restore of an sql database. In local mode I have no problems. Using "SqlDataSourceEnumerator" I get list of lan servers. Start my application correctly, ready the available servers, I connect correctly. The problem that I have when I want to create the path of my Savefile.dialog to locate the backups creates the backup in the machine of the SQL server and not in the machine from which I connect. My question is: how could I solve the route?

 S = save1.FileName;

Query ("Backup database" + cmbBase.Text + "to disk = '" + s + "' WITH INIT");
(Maybe in the route I should add the ip)

thanks for your help.

And how would SQL Server be able to write on a client machine? Should it connect over SMB to it? To which share name? Using which credentials? — CodeCaster, Apr 07 '17 at 14:54
Possibly just a type in your post but you have capital `S` for the filename but then in the query you are using a lowercase `s`. These would point to two different values. — Joshua Hysong, Apr 07 '17 at 14:55
@Joshua Hysong The error of the upper case was mine when transcribing but it is well in the application. — Denis Larramendi, Apr 07 '17 at 15:01
@SpaceUser7448 Thank you. Then that was wrong. Now I have to work on copying the files on the network to get to the end of my application. — Denis Larramendi, Apr 07 '17 at 15:04

score 0 · Accepted Answer · answered Apr 07 '17 at 15:03

0

The BACKUP command in TSQL will not allow a network path to be referenced in the SQL command. So if you backup to (for example) C:\Temp\FRED.BAK, it will always be a path that is local to the machine upon which the SQL Server instance is running.

So to do what I suspect you want to do, you would need to - (a) backup to some folder on the machine running the SQL Server instance and then (b) copy the file from there to a central repository.

I would also add that the RESTORE command in TSQL also does not allow references to network paths, the file being restored also needs to be on a drive local to the machine running the SQL Server instance.

answered Apr 07 '17 at 15:03

SpaceUser7448

189
1
10

Thank you very much for the help. – Denis Larramendi Apr 07 '17 at 15:06
@DenisLarramendi - Can you vote up the answer if it solved your question – SpaceUser7448 Apr 07 '17 at 15:21
Thanks @DenisLarramendi – SpaceUser7448 May 02 '17 at 10:00

backup and restore db sql from C#

1 Answers1