SQL Server Performance

Restore MDF using ldf file?

Discussion in 'ALL SQL SERVER QUESTIONS' started by s_surfer, Jun 11, 2012.

  1. s_surfer New Member

    hi all

    An mdf file was detached and then deleted and now its been found that the mdf is not on any backups. I still have the ldf file. is there anyway or restoring the mdf using the ldf file or is the db gone for good?

    any help would be greatly appreciated

  2. Luis Martin Moderator

    With mdf and without ldf, there is a way but not with only ldf file.
    Anyway wait for others members opinions.
  3. s_surfer New Member

    ok i have found the MDF but its about 2 years old. the LDF is up to date. can I update the MDF using the LDF?
  4. Luis Martin Moderator

    Don't think so.
    You can attach mdf without ldf and start from there.

    BTW: What do you have in "any backups"?. I mean what was the backup strategy?
  5. s_surfer New Member

    it was a full backup using arcserve backup but it looks like that the backup application was not configured to backup the SQL databases on the serevr, it was only set to backup the files in the directory that hosts the databases but as the SQL server was online, the Dbs were not backed up.
  6. Luis Martin Moderator

    Well, try to attach mdf and ldf.
    If you can't do it, attach mdf only, create a new ldf and start from there.
  7. MichaelB Member

    are you sure there are no native backups that were scheduled on the SQL side? could if be you are only aware of one type of backups while there were sql server backups going on and storing elsewhere?

Share This Page