Tuesday, February 14, 2012

corrupted db with error when restore from transactionlog

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
YifeiHi
DBCC CHECKDB did you run?
"Yifei" <yifei.jiang@.sdg.aust.com> wrote in message
news:%23tsGCj7QGHA.5900@.tk2msftngp13.phx.gbl...
> 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
>
>|||the dbcc checkdb returns the error message.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eSSo3ybRGHA.3052@.TK2MSFTNGP09.phx.gbl...
> Hi
> DBCC CHECKDB did you run?
> "Yifei" <yifei.jiang@.sdg.aust.com> wrote in message
> news:%23tsGCj7QGHA.5900@.tk2msftngp13.phx.gbl...
>|||Does anyone know what will cause log file can not be restored?
Cheers
Yifei
"Yifei" <yifei.jiang@.sdg.aust.com> wrote in message
news:%23tsGCj7QGHA.5900@.tk2msftngp13.phx.gbl...
> 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
>
>

No comments:

Post a Comment