|
|
Posted by Erland Sommarskog on 10/01/38 11:30
(Taqyon@gmail.com) writes:
> Is there any way I can restore the database without the LDF file?
Maybe.
If there were no uncommitted transactions in the database at the time of
the crash, all data pages had been flushed to disk etc, the odds are
good.
But if there uncommitted transactions, or pages that had been written
to the log, but not to the data file, you will get a database that is
in poor shape. DBCC may report corruption. It may also come out clean,
but you may still have corruption on application level
If there is any value of that data to you, I stronly recommend you to
open a case with Microsoft, as a support engineer will guide you throuh
all the steps, and can also help you to devise procedures to check the
validity of your data.
If the cost of losing the data does not warrant a support call, but you
still want to give it a shot, I know of method that I will post here.
Simply because if it's applied without understanding, it can cause
even greater mess. Drop me a mail, if you want it.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|