I have a SQL Server 2012 database that must be always in 'standby' mode because I must restore transaction logs from a vendor database to my local database on stand by restoring option.
It has been around 3 months since I started to download log backups from vendor's sFTP server and restore everyday to my database (in standby mode). Today, in the middle of restoring, SSMS crashed and the application closed immediately, which left the database in restoring mode.
I don't want to work all over again from the beginning. How can I change the database to standby mode and keep the sequence of LSNs; from the last LSN restored to next LSN of log backup file?
My database has no log shipping configuration between two servers, it is just a target database.