C# window Form程序
private void button1_Click(object sender, EventArgs e)
        {
            string connectionstring = "server=*******;database=charges;user id=sa;pwd=****";
            //建立连接
            SqlConnection conn = new SqlConnection(connectionstring);
            conn.Open();
            string path = @"F:\Test\数据库备份\datarestor\restor.bak";
            //备份语句
            string backupstr = "backup database charges to disk = '" + path + "'";
            SqlCommand cmd = new SqlCommand(backupstr, conn);
            try
            {
                conn.Open();
                cmd.ExecuteNonQuery();
                MessageBox.Show("备份成功！", "提示");

            }
            catch
            {
                MessageBox.Show("备份失败！", "提示");
            }
            finally
            {
                conn.Close();
            }

        }
结果总是提示“备份失败！”
在 SQL Server的查询分析器中 输入 backup database charges to disk = 'F:\\Test\\数据库备份\\datarestor\\restor.bak';执行，出息设备无法打开F:\\Test\\数据库备份\\datarestor\\restor.bak 访问遭到拒绝的错误。
问题不知道出在了哪里……请各位给看看……

请执行此存储过程
use master
create proc killspid (@dbname varchar(20))        
as        
begin        
declare @sql   nvarchar(500)        
declare @spid  int        
set @sql='declare getspid cursor for select spid from sysprocesses where dbid=db_id('''+@dbname+''')'        
exec (@sql)        
open getspid        
fetch next from getspid into @spid        
while @@fetch_status <> -1        
begin        
exec('kill '+@spid)        
fetch next from getspid into @spid        
end        
close getspid        
deallocate getspid        
end  

学习了

没有学过备份，不过看你的conn.open()两次了！

是不是文件的访问权限有问题。。

private void button1_Click(object sender, EventArgs e)
        {
            string connectionstring = "server=*******;database=charges;user id=sa;pwd=****";
            //建立连接
            SqlConnection conn = new SqlConnection(connectionstring);
            //conn.Open();
            string path = @"F:\Test\数据库备份\datarestor\restor.bak";
            //备份语句
            string backupstr = "backup database charges to disk = '" + path + "'";
            SqlCommand cmd = new SqlCommand(backupstr, conn);

                conn.Open();
                int result = cmd.ExecuteNonQuery();
                if(result > 0)
                MessageBox.Show("备份成功！", "提示");
                else
                MessageBox.Show("备份失败！", "提示");
                     conn.Close();
                     conn.Dispose();
        }

如果是管理员登录的 设置下文件夹所有权就可以了

明白了,谢谢

学习了。