Post
Ask Question

Attach DataBase Without Wizard in Sql Server

  1. exec sp_attach_db @dbname = N'EMployeeDB',   
  2. @DataBasefile1 = N'C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Data\EMployeeDB_Data.mdf',   
  3. @DataBasefilename2 = N'C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Data\EMployeeDB_log.ldf'