Question

C#net做SQL数据库备份，代码该怎么写

Answer 1

我已经测试通过了这段代码：
string sql=@"
BACKUP DATABASE mytest
TO DISK = N'E:\Test\MyTest.dat'--目录一定要存在
WITH INIT , NOUNLOAD ,
NAME = N'数据库备份', --名字随便取
NOSKIP ,
STATS = 10,
NOFORMAT";
try{

SqlConnection conn=new SqlConnection("server=127.0.0.1;uid=sa;pwd=123;database=mytest");
conn.Open();
SqlCommand cmd=new SqlCommand (sql,conn);
cmd.ExecuteNonQuery();
conn.Close();
}catch(Exception ex)
{
Response.Write(ex.Message);
}