I have a SQL server 2014 which backs up database called “YJJ” to a folder. Within that folder I several files. Please see attached excel file for that info. Now just looking at the excel, the full back up [.bak] happens at 2AM daily, followed by [.trn] backups every 30 mins.
So if I want to RESTORE the database to 1/6/2020 with both .bak and .trn…how will I do it?
Also, there is also a [YJJ_Log_bk.bak] which I am not sure what to do?
When doing the backup – I go
Right Click >> Restore Database
Device >> Add >> Select multiple files, starting from .bak at 2AM to all the .TRN files after that time stamps?
Is my approach correct? Or did I missed a step ?
Thanks a lot