Error in attaching Adventureworks 2012 database

• soni321

  Old Hand

  Points: 335

  More actions

  May 27, 2013 at 3:20 pm

  #274214

  TITLE: Microsoft SQL Server Management Studio

  ------------------------------

  Attach database failed for Server '..........\MSSQLSERVER2012'. (Microsoft.SqlServer.Smo)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

  ------------------------------

  ADDITIONAL INFORMATION:

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  Directory lookup for the file "C:\CodePlex Database\AdventureWorks2012_log.ldf" failed with the operating system error 2(The system cannot find the file specified.). (Microsoft SQL Server, Error: 5133)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.2100&EvtSrc=MSSQLServer&EvtID=5133&LinkId=20476

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

• Kingston Dhasian

  SSCoach

  Points: 19799

  More actions

  May 28, 2013 at 12:27 am

  #1618861

  Duplicate post. Please post your replies here.

  http://www.sqlservercentral.com/Forums/Topic1457156-2799-1.aspx

  ---

  Kingston Dhasian

  How to post data/code on a forum to get the best help - Jeff Moden
  http://www.sqlservercentral.com/articles/Best+Practices/61537/