I have some concerns regarding the restore job on secondary server in log shipping in Microsoft SQL Server 2016 for below scenario :
I have two servers, primary and secondary. The backup, copy and restore job frequency is 5 mins. Suppose some disaster happened and primary server is crashed and now we don't have any access to primary server.
On secondary server we have copied 3 log files through log shipping job which are not restored yet.
At present 1st log file is restoring and rest two files still not restored. since our primary server is crashed so we have to make the secondary server Up and make it as primary server.
So before making secondary server as primary How do I ensure that all 3 log files are restored or not ??