log file deleted accidently :(

• shahbaz.oradba

  Right there with Babe

  Points: 769

  More actions

  July 22, 2008 at 3:28 am

  #189972

  i have a full backup of database 'mydb' which iincludes two datafiles and two .ldf files but one of my log file got accidently deleted.

  if i want to restore what should be the process i have to go through ?

• Luzi62

  Ten Centuries

  Points: 1218

  More actions

  July 22, 2008 at 6:59 am

  #846370

  Hi,

  if you have a fullbackup you only need to check the "overwrite the existing database" option in the restore database menu.

  or, with more fun, try this:

  To attach a database with lost log file (ATTACH_REBUILD_LOG )

  CREATE DATABASE database_name

  ON [ ,...n ]

  FOR { ATTACH [ WITH ]

  | ATTACH_REBUILD_LOG }

  [;]

  it's on MSDN SQL Server 2005 Online Doku

  Regards