Attaching a database

• Prasad Bhogadi

  SSCrazy Eights

  Points: 9235

  More actions

  April 8, 2008 at 9:48 am

  #799863

  USE [master]

  GO

  CREATE DATABASE [test] ON

  ( FILENAME = N'c:\temp\test.mdf' ),

  ( FILENAME = N'c:\temp\test.ldf' )

  FOR ATTACH ;

  GO

  Should work for Attaching a db.

  Prasad Bhogadi
  www.inforaise.com

• paul.vickers

  Valued Member

  Points: 71

  More actions

  April 9, 2008 at 1:18 am

  #800194

  Prasad Bhogadi (4/8/2008)

  ---

  USE [master]

  GO

  CREATE DATABASE [test] ON

  ( FILENAME = N'c:\temp\test.mdf' ),

  ( FILENAME = N'c:\temp\test.ldf' )

  FOR ATTACH ;

  GO

  Should work for Attaching a db.

  Thanks Prasad

  sorry for being simple but what do you run this through? e.g. (OSQL)

• Andras Belokosztolszki

  SSC-Insane

  Points: 22031

  More actions

  April 9, 2008 at 1:59 am

  #800201

  You could use osql as well as Management Studio (a graphical fronted, which if you do not have installed can install for SQL Server Express from http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en)

  Regards,

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software