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
>
>
Tuesday, February 14, 2012
corrupted db with error when restore from transactionlog
Labels:
corrupted,
dabase,
database,
dear,
error,
fromyesterday,
index,
microsoft,
mysql,
norecovery,
oracle,
restore,
server,
sql,
transactionlog
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment