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.
Regards,
Trev
Best Answer
There isn't a difference between a restore on a standalone instance and one on a Failover Cluster Instance. There IS a difference if it is in an Availability Group.
Yes you can restore the FULL from Monday and the LOG from 9pm.
Whether or not you have to restore the system databases is dependent upon what you are needing to recover. If it's just data in the user database, then simply restoring the user database is sufficient.