我回复过你的帖子了。。说过方法
            string Sqlstring="EXEC sp_addumpdevice 'disk', '"+diskName+"','"+sTring+"'";
            string Sql="BACKUP DATABASE CprojectData to "+diskName;
这两句 就办到了
注意连接的数据库是master

代码能不能具体一点?

刚写了一个...自己参考一下..
        private void button1_Click(object sender, System.EventArgs e)
        {
            SqlConnection conn=new SqlConnection("Server=purana;DataBase=master;Integrated Security=SSPI");
            SqlCommand cmd=new SqlCommand();
            cmd.CommandType=CommandType.StoredProcedure;
            cmd.CommandText="sp_addumpdevice";
            cmd.Connection=conn;
            cmd.Parameters.Add(new SqlParameter("@devtype",SqlDbType.VarChar,20));
            cmd.Parameters.Add(new SqlParameter("@logicalname",SqlDbType.VarChar,20));
            cmd.Parameters.Add(new SqlParameter("@physicalname",SqlDbType.NVarChar,260));
            cmd.Parameters["@devtype"].Value = "disk";
            cmd.Parameters["@logicalname"].Value="demos";
            cmd.Parameters["@physicalname"].Value=@"D:\MSSQL7\BACKUP\demos.bak";
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();

            cmd.CommandType=CommandType.Text;
            cmd.CommandText="backup database demo to demos";
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
            MessageBox.Show("成功");
        }

你运行过了吗?有问题的~~[em10]

运行了..成功的.

数据库名和一些参数,,请自行修改..

我改了2个参数,运行后有问题.
未处理的"System.Data.SqlClient.SqlException"类型的异常出现在system.data.dll中.
其他信息:系统错误.


private void button1_Click(object sender, System.EventArgs e)
        {
            SqlConnection conn=new SqlConnection("Server=localhost;DataBase=master;Integrated Security=SSPI");
            SqlCommand cmd=new SqlCommand();
            cmd.CommandType=CommandType.StoredProcedure;
            cmd.CommandText="sp_addumpdevice";
            cmd.Connection=conn;
            cmd.Parameters.Add(new SqlParameter("@devtype",SqlDbType.VarChar,20));
            cmd.Parameters.Add(new SqlParameter("@logicalname",SqlDbType.VarChar,20));
            cmd.Parameters.Add(new SqlParameter("@physicalname",SqlDbType.NVarChar,260));
            cmd.Parameters["@devtype"].Value = "disk";
            cmd.Parameters["@logicalname"].Value="demos";
            cmd.Parameters["@physicalname"].Value=@"D:\MSSQL7\BACKUP\demos.bak";
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();

            cmd.CommandType=CommandType.Text;
            cmd.CommandText="backup database train to demos";
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
            MessageBox.Show("成功");

        }

你写存储过程了吗？人家没有贴存储过程出来，还是贴个存储过程给他看看吧