Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)归海一刀published in(发表于) 2014/2/3 6:42:37 分离及附加数据库_[SQL Server教程]
1、分离数据库 exec sp_detach_db dataname--eg: dataname:要分离的数据库名2、附加数据库 1 exec sp_attach_single_file_db newdataname,mdfPath /*eg: newdataname:要附加上的新数据库名称(可以是原来的) mdfPath='C:\Program Files\Microsoft SQL Server\MSSQL\Data\11_Data.MDF' */2. exec sp_attach_db newdataname,mdfPath,ldfPath /*eg: mdfPath='C:\Program Files\Microsoft SQL Server\MSSQL\Data\11_Data.MDF' ldfPath='C:\Program Files\Microsoft SQL Server\MSSQL\Data\11_Log.LDF' */备注:不能操作本数据库 复制C#代码保存代码string DataName = "aaa";string strMdf = "D:\\test1\\test\\Test_Data.MDF";string strLdf = "D:\\test1\\test\\Test_Log.LDF";string strsql = @"EXEC sp_attach_db @dbname = '" + DataName + @"', @filename1='" + strMdf + @"', @filename2= '" + strLdf + "'";SqlConnection myConn = new SqlConnection("Data Source=HUIQIN;Database=master;Persist Security Info=True;UserID=sa;Password=sa");SqlCommand myCommand = new SqlCommand(strsql, myConn);myConn.Open();myCommand.ExecuteNonQuery();myConn.Close();
来源:freeliver54的cnblogs
赞