recover mdf

• hsergios

  SSC Rookie

  Points: 46

  More actions

  August 31, 2004 at 9:47 am

  #65682

  i try attach the db file

  sp_attach_single_file_db 'TESTE','C:\TEMP2\PONTOFACIL.MDF'

  and show me the error

  Server: Msg 945, Level 14, State 2, Line 1

  Database 'TESTE' cannot be opened because some of the files could not be activated.

  Server: Msg 1813, Level 16, State 2, Line 1

  Could not open new database 'TESTE'. CREATE DATABASE is aborted.

  what can i do for recover this db

   

   

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  August 31, 2004 at 9:58 am

  #521250

  This could be the problem: http://support.microsoft.com/default.aspx?scid=kb;en-us;271223

  Do you now have the ldf? Did you detach the db?

  You can also try this: http://eai.ittoolbox.com/groups/groups.asp?v=SQL-SERVER-L&i=424438