Recover Bad Logs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Davoli - 29 Feb 2008 20:27 GMT

SQL Server 2000

We have a database that crashed and the log file is bad and the last good
backup was october, so the transaction log is bigger than the data file.
Since the transaction log is corrupt,and we have no backups because the last
good backup was october, can I do something with that corrupt transaction log
to get those transactions out of it and bring forward the database to be
current with all transactions???

Need some help. This is a production DB.

Signature

Chris Davoli

Reply to this Message

Greg D. Moore (Strider) - 29 Feb 2008 21:56 GMT

> SQL Server 2000
>
[quoted text clipped - 8 lines]
>
> Need some help. This is a production DB.

Reply to this Message

Greg D. Moore (Strider) - 29 Feb 2008 21:57 GMT

> SQL Server 2000
>
[quoted text clipped - 6 lines]
> to get those transactions out of it and bring forward the database to be
> current with all transactions???

Call Microsoft. Most likely your DB is hosed. But sometimes they can work
miracles.

> Need some help. This is a production DB.

Signature

Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Reply to this Message