I have a Windows 2008 R2 server that needs to be periodically reset to a clean state. Normally I would look at creating an image of the system drive, however due to organizational reasons I cannot use an image for this purpose.
So what I'm working on is using a combination of Windows System Restore and SQL's internal backup. The piece I'm missing right now is how to actually back up the SQL 2008 R2 Instance and associated configuration settings.
Basically I would like to be able to save a snapshot of the instance itself (logins, schemas, defaults, etc.) as well as anything necessary to restore the application to a working state from a bare metal restore (so things like service owners and registry keys).
Does SQL itself have a way to do this or do I have to look for another way to back up the application? For the logins, schemas and defaults, are those contained within one of the system databases?