SYSPREP tool in Microsoft SQL Server 2008 R2

SYSPREP has been a great tool in the virtualized world for building golden copy images for your system that helps to ensure standardization across the enterprise. SQL Server 2008R2 now supports building golden copy for your SQL Servers. Combine this ability to SYSPREP your SQL Server and you can build a bare metal build architecture […]

SYSPREP has been a great tool in the virtualized world for building golden copy images for your system that helps to ensure standardization across the enterprise. SQL Server 2008R2 now supports building golden copy for your SQL Servers. Combine this ability to SYSPREP your SQL Server and you can build a bare metal build architecture that now contains your SQL Servers. So we take this one step further and deploy this with Hyper-V and NetApp's FlexClone Technology, now you can deploy hundreds of brand new SQL Server instances within minutes, no longer hours and days. This ability to manage a golden copy and quickly deploy complete systems to include your golden SQL Server setup reduces configuration & customization time for new database system, and will help you manage your entire SQL Server environment reducing configuration mistakes and delays.

The setup command:c:\sqlimage\setup.exe /ConfigurationFile=BellevueLabSQL.INI; allows to create a hands free setup and can be part of bare metal provisioning process. This method reduces the amount of time spend creating & configuring systems in my lab.

[Source]