从c＃备份SQL数据库 [英] SQL Database back up from c#

问题描述

我正在使用c＃winforms，sql server 2005.i已完成数据库备份，从c＃



ref { http://stackoverflow.com/questions/16913215/ backup-and-restore-database-mdf -c-sharp-winform-didnt-work [ ^ ]}。



但它显示像

这样的错误无法打开备份设备'F：\\'。操作系统错误3（系统找不到指定的路径。）。\\\\ nnBACKUP DATABASE正在异常终止。

每个语法很好，但它显示错误

解决方案

试试这个...... :)

 使用 Microsoft.SqlServer.Management.Smo; 
 
  var  bdi =  new  BackupDeviceItem（ / *  您的路径包含所需的文件* / ）; 
  var  backup =  new 备份
 {
数据库=  / *  数据库名称* / ，
 Initialize =  true  
}; 
 
 backup.Devices.Add（bdi）; 
 
  var  server =  new 服务器（此 .SqlServer）; 
 
 尝试 
 {
 backup.SqlBackup（server）; 
} 
  catch （例外情况）
 {
  //   * log or sth  
} 

看看这里：< a href =http://www.codeproject.com/Tips/461494/Backing-up-an-SQL-Database-in-Csharp>用C＃备份SQL数据库 [ ^ ]

试试这个.. :)



http://edwardthienhoang.wordpress.com/2013/04/10/sql-server-database-backup-using-c/ [ ^ ]

Hi,
I am working with c# winforms, sql server 2005.i have completed database back up from c#

ref{http://stackoverflow.com/questions/16913215/backup-and-restore-database-mdf-c-sharp-winform-didnt-work[^]}.

but it shows an error like

Cannot open backup device 'F:\\'. Operating system error 3(The system cannot find the path specified.).\r\nBACKUP DATABASE is terminating abnormally.

every syntax is good but it shows an error

解决方案

try this...:)

using Microsoft.SqlServer.Management.Smo;

var bdi = new BackupDeviceItem(/* your path inlcuding desired file */);
var backup = new Backup
{
    Database = /* name of the database */,
    Initialize = true
};

backup.Devices.Add(bdi);

var server = new Server(this.SqlServer);

try
{
    backup.SqlBackup(server);
}
catch (Exception ex)
{
    // * log or sth
}

Have a look here: Backing up an SQL Database in C#[^]

try this..:)

http://edwardthienhoang.wordpress.com/2013/04/10/sql-server-database-backup-using-c/[^]

这篇关于从c＃备份SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！