June 18, 2016 at 10:44 am
As part of log-shipping when restoring on of the logs gave below error message. I had to restore the db from full and diff to get it back on track. I am trying to find if i can get page or table name using log record ID (1797221:955720:167).
Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.During redoing of a logged operation in database 'ABC, an error occurred at log record ID (1797221:955720:167). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.
The backup or restore was aborted.
June 20, 2016 at 1:55 pm
I will give that a try. I also wanted to know what is my page id in log record ID (1797221:955720:167).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply