|
Home > Archive > MS SQL Server > March 2006 > it does not work, any other way can fix the problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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@discussion
s.microsoft.com> wrote in message
news:CAB37071-866D-49C2-8CAE- 933A12619257@microso
ft.com...[color=darkred]
> 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...;Q32
4469
>
> --
> 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:
>
| |
| Sreejith G 2006-03-09, 7:23 am |
| 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@discussion
s.microsoft.com> wrote in message
> news:CAB37071-866D-49C2-8CAE- 933A12619257@microso
ft.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@discussion
s.microsoft.com> wrote in message
news:AAF39FB4-86D4-4DF9-BA49- ACB3CD759F17@microso
ft.com...[color=darkred]
> 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:
>
|
|
|
|
|