it does not work, any other way can fix the problem

Hi, Sreejith,
Actually, the server is sql 2000 standard with sp4, the article suggested
sp3 will do, so I don't think this is the sp issue,
the worst thing is I can restore from back up database file but I can not
restore the transaction log file from another day,
for example, restored db from the day before yesterday, and cannot restore
log file, got same error message. I will try to see if only this db or it it
apply for all of dbs. It is really a disaster if all the dbs are same.
by the way, the database has two db files in different disks
Please help on this matter.
Many thanks
Yifei
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:CAB37071-866D-49C2-8CAE-933A12619257@.microsoft.com...[vbcol=seagreen]
> Hope urs is Sql Server 2000
> RESOLUTION
> SQL Server 2000
> To resolve this problem, obtain the latest service pack for Microsoft SQL
> Server 2000.
> Read more below...
> http://support.microsoft.com/defaul...5BLN%5D;Q324469
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread an
d
> time
> asking back if its 2000 or 2005]
>
> "Yifei" wrote:
>Can you please post the error message while appyling the transaction log?
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and
time
asking back if its 2000 or 2005]
"Yifei" wrote:

> Hi, Sreejith,
> Actually, the server is sql 2000 standard with sp4, the article suggested
> sp3 will do, so I don't think this is the sp issue,
> the worst thing is I can restore from back up database file but I can not
> restore the transaction log file from another day,
> for example, restored db from the day before yesterday, and cannot restore
> log file, got same error message. I will try to see if only this db or it
it
> apply for all of dbs. It is really a disaster if all the dbs are same.
> by the way, the database has two db files in different disks
> Please help on this matter.
> Many thanks
> Yifei
>
> "Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
> news:CAB37071-866D-49C2-8CAE-933A12619257@.microsoft.com...
>
>|||this is the error message
Processed 374033 pages for database 'database', file 'log_file' on file 1.
Server: Msg 9004, Level 21, State 20, Line 1
An error occurred while processing the log for database ' '.
Connection Broken
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:AAF39FB4-86D4-4DF9-BA49-ACB3CD759F17@.microsoft.com...[vbcol=seagreen]
> Can you please post the error message while appyling the transaction log?
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread an
d
> time
> asking back if its 2000 or 2005]
>
> "Yifei" wrote:
>