数据附加转移目录

 alter database test
 modify file (name=test,filename='D:\Mokey_Codes\db\test.mdf')
 
  alter database test
   modify file (name=test_log,filename='D:\Mokey_Codes\db\test.ldf')
   
   
   alter database test
   set offline with rollback immediate
   
      
   alter database test
   set online