try
        {
            string myConnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            SqlConnection con = new SqlConnection(myConnection);
            con.Open();
            string myExecuteQuery = "backup database Database to  disk='d:\backuptext.dat'";
            
            SqlCommand myCommand = new SqlCommand(myExecuteQuery,con);
         
            myCommand.ExecuteNonQuery();
            con.Close();
            Label1.Text = "备份成功";
        }
        catch { Label1.Text = "备份失败"; }


老是备份失败，帮我看看指明下那里错了……

[ 本帖最后由 wyx814 于 2010-11-22 22:45 编辑 ]

catch(Exception ex)
{
    Label1.Text="备份失败"+ex.ToString();
}
这样写后,看Label1的文本上ex的信息.可以看到它报的什么错!

BACKUP DATABASE [Database] TO  DISK = N'd:\backuptext.dat' WITH NOFORMAT, INIT,  NAME = N'Database-完整 数据库 备份', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
试试这个语句吧，记得注意一点，方括号很重要，因为你写的是database，这是关键词，必须加方括号，数据库才会认