I'm working on a way to restore a Windows Server machine to a particular point in time without using an image (there are organizational reasons why we can't just image the system drive), and since I'm working with a Windows Server 2008 R2 environment I've been investigating the Windows Server Backup. The server is a SQL server, running SQL 2008 R2 and nothing else, but what I'd like to restore is:
- Windows Server configuration (what roles are installed, services are active, logins configured)
- SQL Server configuration (what logins are configured to the instance, how SQL options are configured)
I do not need Windows to backup or restore actual databases, as I'm handling that as a separate step.
My question is that if I only have a C: that SQL and Windows are installed on, will a System State restore cover both of the above objectives?
Or do I need to somehow recover the entire C: volume?