We have been given a .bak file of a database from our vendor on a completely different network. They are placing their .trn files every 15 minutes on a sftp for us to pickup and write to the .bak file they sent us. This way we will have data up-to-date every 15 minutes or so.
What I have done is restored their backup
WITH NORECOVERY. Then I restored all 800 .trn files
WITH NORECOVERY, setting the last restore to
WITH RECOVERY. Now that it is out of
NO RECOVERY we can read from the DB.
Now that we are up-to-date, what is the process for restoring the new .trn files that they send us?
I apologize for the ignorance, I am new to the DBA game.