天天看點

批處理附加、分離資料庫

附加:sqlcmd -d master -Q "exec sp_attach_db @dbname='HealthExamining',@filename1='%CD%/DB/HealthExamining.mdf',@filename2='%CD%/DB/HealthExamining_log.ldf'"

分離:sqlcmd -d master -Q "exec sp_detach_db @dbname=HealthExamining"