--EXEC sp_detach_db @dbname = 'jshh'
--EXEC sp_attach_single_file_db @dbname = 'jshh',
-- @physname = 'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\jshh.mdf'
-------------------
/*
a.分离
EXEC sp_detach_db @dbname = '库名'
b.删除日志文件
c.再附加
EXEC sp_attach_single_file_db @dbname = '库名',
@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\库名.mdf'
*/