recover from log file

Last Post 29 Jun 2006 02:02 AM by mwesch. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

29 Jun 2006 12:35 AM
My name is Pedro.

I have a lost the data file from my database (the database is suspect).
i can recover the database using the log file.
Can someone tell me what is the sintax to do this?

Thank you very mutch,

New Member
New Member

29 Jun 2006 02:02 AM
No, you can't recover it from the log file.

You need to restore database from recent full backup. If you want to restore transaction log backups as well. then leave the database in non-operational mode until last log file is restored.

If backups aren't available then I suggest to call Microsoft support. They are often able to recover suspect database through undocumented tricks.

Acceptable Use Policy