SQL Database Attach and Detach Script

             DATABASE ATTACH SCRIPT

1   .In this example Adventureworks database data and log file exists in “C:\Adventureworks2008R2_Database”  folder.

2.  Run the below command 

  USE Master

  Go

  EXEC sp_attach_db @dbname = 'AdventureWorks',

    

 @filename1 = 'C:\AdventureWorks2008R2_Database\AdventureWorks2008R2_Data.mdf',

    

 @filename2 = 'C:\AdventureWorks2008R2_Database\AdventureWorks2008R2_log.ldf'

               DATABASE DeTACH SCRIPT

   

  USE Master

    Go

    EXEC sp_detach_db @dbname = 'AdventureWorks'