up vote 1 down vote favorite
share [g+] share [fb]

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

link|improve this question
1  
Try this on ServerFault. – Lance Roberts Jan 14 '10 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 '10 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 '10 at 17:49
feedback

migrated from stackoverflow.com Jan 14 '10 at 16:55

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 3 down vote

Look up sp_attach_single_file_db in BOL.

Also you can use:

CREATE DATABASE dbname ON <file> [,...n] FOR ATTACH_REBUILD_LOG
link|improve this answer
feedback
up vote 1 down vote

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

link|improve this answer
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 '10 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 '10 at 17:24
feedback

Your Answer

 
or
required, but never shown
discard