服务器上的mysql自动备份到本地计算机,将数据库从远程服务器备份到本地计算机。...

Hi,

i am taking backup of database from remote server using smo but my problem is backup file is getting stored on remote machine.i want same backup file should be created on local machine instead of remote machine in C# using smo.

how can i achive this using smo in C#.

解决方案

First, typically it''s not a good idea to create a backup on remote computer. If this is just a single case, then fine. But if you''re going to do this repeatedly what''s going to happen for example in case of a network failure, you don''t have a backup at all...

But to the answer. This can be done in numerous ways. The easiest way is direct the backup to remote computer is to use UNC paths. You can use them in the backup command or you can predefine a dump device. Te get more info, have a look at sp_addumpdevice[^] and especially example B.

SQL Server can only ever back up to a drive physically attached to the actual SQL Server machine. You cannot under any circumstances back up a remote SQL Server to your local harddisk - just not possible (neither in SMO, or in SQL Server Management Studio).

As a workaround you can make that your database call a command line program in the host, that send the file by ftp, copy it to some shared folder.