|
Home > Archive > MS SQL Server > March 2006 > Help, please, corrupted db with error when recovering
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 |
Help, please, corrupted db with error when recovering
|
|
|
| Dear All,
A dabase index corrupted yesterday, and then we restore the database from
yesterday early morning with norecovery option, when I try to restore log,
get error message:
sql server is stand edit with sp4
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
Anyone can help me, please?
Thanks
Yifei
| |
| Sreejith G 2006-03-09, 3:23 am |
| 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:
> Dear All,
>
> A dabase index corrupted yesterday, and then we restore the database from
> yesterday early morning with norecovery option, when I try to restore log,
> get error message:
>
> sql server is stand edit with sp4
>
> 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
>
> Anyone can help me, please?
>
> Thanks
>
> Yifei
>
>
>
|
|
|
|
|