1

I have a *.mdf and *.ndf files but *.log is missing. Is it possible to recover the database?

Improve this question
3
  • 1
    Try this on ServerFault.
    – Lance Roberts
    Jan 14, 2010 at 16:37
  • Why it is programming related as well as this can be done using valid T-SQL. I don't think the server fault folks know that much TSQL.
    – JonH
    Jan 14, 2010 at 16:39
  • Are we to guess that you're talking about Microsoft SQL Server? Please be specific. SQL is a language, not a system.
    – John Gardeniers
    Jan 14, 2010 at 17:49

2 Answers 2

Reset to default
4

Look up sp_attach_single_file_db in BOL.

Also you can use:

CREATE DATABASE dbname ON <file> [,...n] FOR ATTACH_REBUILD_LOG
Improve this answer
1

With some third party tools you can. We used Lumigent Log Explorer, which is no longer available. However, if you do a Google (or Bing) search, you will come up with all sorts of alternatives to Log Explorer.

However, your question will get a better answer on serverfault.com

Improve this answer
2
  • I think he will get a better answer on here as it is TSQL related. Serverfault may help if he is looking for a backup but he doesn't have a backup.
    – JonH
    Jan 14, 2010 at 16:44
  • @JonH We here on ServerFault know as much or more about administrative T-SQL as the folks at StackOverflow (where many of us also post).
    – phoebus
    Jan 14, 2010 at 17:24

You must log in to answer this question.