好像如果你的recovery mode是full的话,默认就是备份transaction log的。单独备份log也是可以的
看看下面链接里的B. Backing up the database and log 部分
http://msdn.microsoft.com/en-us/library/ms186865.aspx
看看下面链接里的B. Backing up the database and log 部分
http://msdn.microsoft.com/en-us/library/ms186865.aspx
DECLARE @FILENAME VARCHAR(100)
SET @FILENAME=''D:\DataBackup\CSMS_backup_''+CONVERT(VARCHAR(8),GETDATE(),112)+REPLACE(CONVERT(char(5),GetDate(),108),'':'','''')+''.bak ''
backup database CSMS to disk=@FILENAME with init', @database_name=N'master', @flags=0
//数据库绑定下拉框显示数据库名称
public void binddropdownList()
{
string cmdtxt1 = "Server=(local);DataBase=master;Uid=sa;Pwd=";
string cmdtxt2 = "Exec sp_helpdb";
SqlConnection Con = new SqlConnection(cmdtxt1);
Con.Open();//打开数据库连接
SqlCommand mycommand = new SqlCommand(cmdtxt2, Con);
SqlDataReader dr = mycommand.ExecuteReader();
this.DDLDataBase.DataSource = dr;
this.DDLDataBase.DataTextField = "name";
this.DDLDataBase.DataBind();
dr.Close();//关闭适配器
Con.Close();//关闭数据库连接
}//codego.net/tags/11/1/
//点击备份数据
protected void ImgBtnOK_Click(object sender, ImageClickEventArgs e)
{ string cmdtxt1 = "Server=(local);database='" + this.DDLDataBase.SelectedValue + "';Uid=sa;Pwd=";
string cmdtxt2 = "backup database " + this.DDLDataBase.SelectedValue + " to disk='" + this.TextBox1.Text.Trim() + ".bak'";
SqlConnection Con = new SqlConnection(cmdtxt1);
Con.Open();//打开数据库的链接
try
{
SqlCommand Com = new SqlCommand(cmdtxt2, Con);
Com.ExecuteNonQuery();
Response.Write("<script language=javascript>alert('备份数据成功!');location='javascript:history.go(-1)'</script>");
}
catch (Exception ms)
{
Response.Write(ms.Message);
Response.Write("<script language=javascript>alert('备份数据失败!');location='javascript:history.go(-1)'</script>");
}
finally
{
Con.Close();
}
}