SQLServer 2008 分离、附加、删除数据文件

分离数据库：

[SERVER1_OS(1)_ALG_201810090000_201810151739]

附加数据库：

EXEC sp_attach_db @dbname = N'SERVER1_OS(1)_ALG_201810090000_201810151739',
@filename1 = N'D:\AlarmLogging\SERVER1_OS(1)_ALG_201810090000_201810151739.mdf',
@filename2 = N'D:\AlarmLogging\SERVER1_OS(1)_ALG_201810090000_201810151739.ldf'

删除数据库

DROP DATABASE database_name [ ,...n ]