I have a 2-node clustered Lab SQL Server and I need to restore the database to the previous day state. This is my first time to try a restore in a cluster. I have a full recovery model and since this environment is rarely used, I have a once a week full backup complemented by 2 differential backups and daily log backups; i.e. Full=Mondays at 1am, Diff=Wed and Fri at 1am, and Log=daily at 9pm.
Now my questions is - if I wish to restore the database on the Monday state, can I simply restore the full backup on Monday (1am), then restore log backup on same day (9pm), then recover the database?
Do I have to worry about restoring any of the master, model or msdb system databases?
Thanks in advance.