Re: Attaching MDF without LDF
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 27 Oct 2005 21:03:58 +0000 (UTC)
(Taqyon@xxxxxxxxx) 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@xxxxxxxxxxxxx
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.
- Follow-Ups:
- Re: Attaching MDF without LDF
- From: Taqyon
- Re: Attaching MDF without LDF
- Prev by Date: Re: Bulk Insert Data in Millions - Lock Issue
- Next by Date: Re: Statement for returning stored procedure params
- Previous by thread: MSDE and two instances on the same server?
- Next by thread: Re: Attaching MDF without LDF
- Index(es):
Relevant Pages
|
