问题1 装U8的心得.docxVIP

安装用友软件注意系统一定不能是家庭版的否则IIS服务装不上。装数据库之前一定要先检查计算机名称并重启生效。装完后修复时是个漫长的过程。所以就只能备份原数据库。（恢复帐套步骤，先在另一台机器上装上软件，正常引进备份的帐套然后，然后停止数据库服务进企业管理器把对应的帐套数据库分离，然后附加备份的原数据库MDF标签：数据库连接异常今天在做数据库备份程序的时候出现了这样的异常。代码为///杀死原来所有的数据库连接进程??????????? SqlConnection conn = new SqlConnection();??????????? conn.ConnectionString = Data Source=.;Initial Catalog=master;User ID=sa;pwd =123456;??????????? conn.Open();??????????? string sql = SELECT spid FROM sysprocesses ,sysdatabases WHERE sysprocesses.dbid=sysdatabases.dbid AND sysdatabases.Name= + ????????????????????????? jc+ ;??????????? SqlCommand cmd1 = new SqlCommand(sql, conn);??????????? SqlDataReader dr;??????????? ArrayList list = new ArrayList();??????????? try??????????? {??????????????? dr = cmd1.ExecuteReader();??????????????? while (dr.Read())??????????????? {??????????????????? list.Add(dr.GetInt16(0));??????????????? }??????????????? dr.Close();??????????? }??????????? catch (SqlException eee)??????????? {??????????????? MessageBox.Show(eee.ToString());??????????? }??????????? finally??????????? {??????????????? conn.Close();??????????? }??????????? //MessageBox.Show(list.Count.ToString());??????????? for (int i = 0; i list.Count; i++)??????????? {??????????????? conn.Open();??????????????? cmd1 = new SqlCommand(string.Format(KILL {0}, list[i].ToString()), conn);??????????????? cmd1.ExecuteNonQuery();??????????????? conn.Close();??????????????? MessageBox.Show(系统已经清除的数据库线程： + list[i].ToString() + \r\n正在还原数据库！);??????????? }??????????? //这里一定要是master数据库，而不能是要还原的数据库，因为这样便变成了有其它进程??????????? //占用了数据库。??????????? string constr = @Data Source=.;Initial Catalog=master;User ID=sa;pwd =123456;??????????? string database = jc;??????????? string path = backfile;??????????? string BACKUP = String.Format(RESTORE DATABASE {0} FROM DISK = {1} with replace, database, path);??????????? SqlConnection con = new SqlConnection(constr);??????????? SqlCommand cmd = new SqlCommand(BACKUP, con);??????????? con.Open();??????????? try??????????? {???????????????