recover from log file

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

--
29 Jun 2006 01:35 AM
HI-there
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,

Pedro
mwesch
New Member
New Member

--
29 Jun 2006 03: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
---