Skip to end of metadata
Go to start of metadata

showrecovery [(dbid | dbname)]

Show recovery diagnostics for database <dbid>/<dbname>.

 

1> dbcc showrecovery

2> go

 

Recovery Log Markers:

        Checkpoint Log Record: (521145198, 21)

        First Log Record: (516510375, 14)

        Last Log Record: (521145198, 21)

Analysis Statistics:

        Log I/O Size: 32768

        Total records to scan: 149658428

                Number of records in phase 1: 0 (0.0%)

                        Number of records to redo in phase 1: 3 (100.0%)

                Number of records in phase 2: 149658428 (100.0%)

                        Number of records to redo in phase 2: 149658428 (100.0%)

                Total number of log records to redo: 149658431 (100.0%)

Redo Statistics:

        Total operations considered for redo: 5

                Operations that did not need redo (PFTS check): 3 (60.0%)

                Operations that might need redo (PFTS check): 0 (0.0%)

                Operations that needed redo (timestamp check): 0 (0.0%)

                Operations that did not need redo (timestamp check): 2 (40.0%)

        Total number of log records to undo: 4

 

 

 

  • No labels