2

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.

  • 2
    I recommend you tag your question with your RDBMS (oracle? sql server? mysql? other?) since any answers are likely going to be vendor specific – markp Dec 6 '17 at 17:13
  • Question asked: "is the database a read only purpose (no changes introduced) in your side?" – ypercubeᵀᴹ Dec 11 '17 at 14:36
6

Can you set database to No Recovery, apply transaction Logs, then set to Recover. Do that every hour? is that possible?

No .. once you recover, you cannot apply transaction logs anymore. You have to start again.

What you can do is ... apply transaction log and have the db in standby using .. restore .. with Standby (available for read queries).

RESTORE LOG MyAdvWorks
   FROM MyAdvWorks_log1
   WITH STANDBY = 'c:\undo.ldf'
GO

Alternatively, you can also ask the vendor to compress the backups to reduce size.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.