天天看点

批处理附加、分离数据库

附加: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"