Is it possible to restore SQL Transaction Logs to a MS SQL database every hour without having to restore the full backup first?
Can you set database to No Recovery, apply transaction Logs, then set to Recover. Do that every hour? is that possible?
Reason for question is that the vendor is sending a full database backup each morning and instead of the large backup being sent they rather send T-Logs throughout the day.