MDF文件的恢复

昨天误操作,把系统弄崩溃了,不得不重装系统.sql server 2005的数据库恢复,以防以后自己忘记.

sp_attach_db [ @dbname= ] 'dbname'
        , [ @filename1= ] 'filename_n' [ ,...16 ] 

eg:

EXEC sp_attach_db @dbname = N'AdventureWorks',
    @filename1 = N'c:\Program Files\Microsoft SQL Server
        \MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf',
    @filename2 = N'c:\Program Files\Microsoft SQL Server
        \MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf' ;