IBM Support

MSSQL DB went into Restoring mode while performing log based recovery

Question & Answer


Question

MSSQL DB went into Restoring mode while performing log based recovery

Answer

Issue
?1) Restore log Operation was happening in DR Database, at that movement Cluster movement happened, so .Trn logs drive were not avail on other node & it is getting failed
?2) Standby Database went into restoring mode, due trn log restoration was in progress & not able to restore further logs
?Solution
?3) Move the DB cluster to the actual node
?4) Executed the query ? restore database databasename with norecovery? Query should get success, but database mode remains same as restoring
?5) We should know the last restored logs in DR database before issue occurred
?6) Move the .ckp (checkpoint) file to other location
?7) Restore the last log (further logs to be applied) with standby mode by GUI

[{"Business Unit":{"code":"BU051","label":"N\/A"},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB33","label":"N\/A"}}]

Document Information

More support for:
IBM Worldwide Support

Software version:
All Versions

Document number:
782667

Modified date:
02 November 2020

UID

ibm10782667

Page Feedback