分别及附加数据库

一、分离数据库
   exec sp_detach_db dataname
   eg: dataname:要分离的数目库名
二、附加数据库
  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’
备考:不能够操作本数据库
eg:
        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();

相关文章