Dear All,

I have a database which gets refreshed on the daily by restoring 1 transactional file log, at the moment it is done manually but I'm trying to create an automation job which would get the transactional life file and restoring it, is it at all possible to achieve please?


Thank you in advance!

Yes this is possible you need to create job to do so. I would first guide you to below link

You need to first copy the log file using xcopy or robocopy and then use this link to automate restore

do you want to have write capability on the database which is restored? If its read-only copy then you might want to use Log Shipping feature which is inbuilt with SQL Server.

If you want regular backup restore, then you need to write your own code.