RE: Rebuild .LDF File
From: Steve (anonymous_at_discussions.microsoft.com)
Date: 09/28/04
- Next message: DBA: "Re: Need to shrink live DB"
- Previous message: Aaron [SQL Server MVP]: "Re: SQL Injection Prevention"
- In reply to: Nigel Rivett: "RE: Rebuild .LDF File"
- Next in thread: Peter The Spate: "Rebuild .LDF File"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 28 Sep 2004 07:57:49 -0700
Ok, I just tried your instructions and it didn't work.
The database is in emergency mode, and I can't see any of
the tables, and when I try to setup a dts, I get an error
saying that it can't initialize the database.
>-----Original Message-----
>If sp_attach_single_file doesn't work then see
>http://www.nigelrivett.net/RecoverCorruptDatabase.html
>
>"Steve" wrote:
>
>> I'm running SQL Server 2000, trying to rebuild a
>> transaction log since I only have an .MDF file. I've
tried
>> creating a new database with the same name, stopping
SQL
>> Server, then inserting the real data file, and setting
the
>> database to emergency mode, then running the DBBC
>> Rebuild_Log('dbname', 'c:\somepath') and that command
>> appears to execute ok in Query Analyzer, but the log
file
>> is not created. Is there any other method for attaching
>> the .mdf when you don't have the valid .ldf that goes
with
>> it. (I've tried sp_attach_single_file) and that doesn't
>> work either. I get an error message that says it can't
>> find the log file (this db was pulled off of another
>> system that had the log file path stored pointed to
>> another drive). Any help is appreciated.
>>
>> Thanks
>>
>.
>
- Next message: DBA: "Re: Need to shrink live DB"
- Previous message: Aaron [SQL Server MVP]: "Re: SQL Injection Prevention"
- In reply to: Nigel Rivett: "RE: Rebuild .LDF File"
- Next in thread: Peter The Spate: "Rebuild .LDF File"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
