数据库文件还在的话可以用sp_attach_db
进入Query Analyzer
语法如下EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'd:\mssql7\data\pubs.mdf',
@filename2 = N'd:\mssql7\data\pubs_log.ldf'
进入Query Analyzer
语法如下EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'd:\mssql7\data\pubs.mdf',
@filename2 = N'd:\mssql7\data\pubs_log.ldf'
语法如下EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'd:\mssql7\data\pubs_Data.mdf',
@filename2 = N'd:\mssql7\data\pubs_log.ldf'