A great option for those of us who live by virtual environments, SQL Server 2008 R2 sysprep
- by Enrique Lima
For a long time when creating images for my development environment, I had to install the OS and then sysprep. Only after that would I then create a differencing drive/image that would have SQL Server. So, the thought of having a base/core image for SQL Server as a template was not easily done. Well, how do things change? SQL Server 2008 R2 gives us the option now.
Check this HOW TO provided on the library docs at TechNet.
http://technet.microsoft.com/en-us/library/ee210664(SQL.105).aspx