![\"parkerj\"](\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8562.parkerj_thumb_2B5FBACF.jpg\" "\\"parkerj\\"")
<\/a><\/p>\nWith Microsoft\u2019s new release of SQL Server, there are a couple of things that I feel would be great to talk about.\u00a0 The main topic that I want to discuss is SYSPREP.\u00a0 <\/p>\n
SYSPREP has been a great tool in the virtualized world for building golden copy images for your system.\u00a0 The use of the golden copy helps to ensure standardization across the enterprise.\u00a0 The release of SQL Server 2008R2 now supports building that golden copy for your SQL Servers.\u00a0 Combine this ability to SYSPREP your SQL Server and you can build a bare metal build architecture that now contains your SQL Servers.\u00a0 So we take this one step further and deploy this with Hyper-V and NetApp\u2019s FlexClone Technology, now you can deploy hundreds of brand new SQL Server instances within minutes, no longer hours and days.\u00a0 This ability to manage a golden copy and quickly deploy complete systems to include your golden SQL Server setup reduces the configuration and customization time for new database system. this reduction of configuration and customization will help you manage your entire SQL Server environment reducing configuration mistakes and delays.<\/p>\n
NetApp participated in the TAP program testing the SYSPREP features with SQL Server 2008\u00a0 R2.\u00a0 As one of the testers I found it really simple to deploy an image of my golden setup with SYSPREP.\u00a0 The process is simple, you run the setup program, select the Advanced feature and \u201cImage preparation of a stand-alone SQL Server\u201d option and the wizard takes you through the process for building your image.<\/p>\n
The key things that I had to look out for was having enough disk space to hold the image and realizing that it was really just as simple as following the steps outlined in Books-Online.\u00a0 Once you have your image then your set and your configuration ini file then you have everything you need to deploy your SQL environment. There is also the command prompt method where you enter all the configuration items but personally I like using a configuration ini file to ensure that each setup is like the rest.<\/p>\n
The setup command looks like the following:<\/p>\n
c:\\sqlimage\\setup.exe \/ConfigurationFile=BellevueLabSQL.INI<\/p>\n
This allows me to create a hands free setup and can be part of my bare metal provisioning process.\u00a0 This method reduces the amount of time I spend creating and configuring systems in my lab. <\/p>\n
So wrapping this up. I find that the SYSPREP tools with SQL Server 2008 R2 will help to make the deployment of new SQL Server instances fast, easy and with fewer configuration differences.\u00a0 Then tying the entire provisioning process together now you can deploy your new systems in Hyper-V along with your SQL Server instance all in a single automated process.<\/p>\n","protected":false},"excerpt":{"rendered":"
\u00a0 Guest blogger: John S. Parker \u2013 NetApp Microsoft Alliance Engineering Team With Microsoft\u2019s new release of SQL Server, there are a couple of things that I feel would be great to talk about.\u00a0 The main topic that I want to discuss is SYSPREP.\u00a0 SYSPREP has been a great tool in the virtualized world for<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2445],"topic":[],"coauthors":[2487],"class_list":["post-5033","post","type-post","status-publish","format-standard","hentry","content-type-thought-leadership"],"yoast_head":"\n
SYSPREP in SQL Server 2008 R2 - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SYSPREP in SQL Server 2008 R2 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"\u00a0 Guest blogger: John S. Parker \u2013 NetApp Microsoft Alliance Engineering Team With Microsoft\u2019s new release of SQL Server, there are a couple of things that I feel would be great to talk about.\u00a0 The main topic that I want to discuss is SYSPREP.\u00a0 SYSPREP has been a great tool in the virtualized world for\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2010-06-15T21:01:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8562.parkerj_thumb_2B5FBACF.jpg\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SYSPREP in SQL Server 2008 R2\",\"datePublished\":\"2010-06-15T21:01:00+00:00\",\"dateModified\":\"2024-01-23T06:50:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/\"},\"wordCount\":470,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8562.parkerj_thumb_2B5FBACF.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/\",\"name\":\"SYSPREP in SQL Server 2008 R2 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8562.parkerj_thumb_2B5FBACF.jpg\",\"datePublished\":\"2010-06-15T21:01:00+00:00\",\"dateModified\":\"2024-01-23T06:50:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8562.parkerj_thumb_2B5FBACF.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8562.parkerj_thumb_2B5FBACF.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SYSPREP in SQL Server 2008 R2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SYSPREP in SQL Server 2008 R2 - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/","og_locale":"en_US","og_type":"article","og_title":"SYSPREP in SQL Server 2008 R2 - Microsoft SQL Server Blog","og_description":"\u00a0 Guest blogger: John S. Parker \u2013 NetApp Microsoft Alliance Engineering Team With Microsoft\u2019s new release of SQL Server, there are a couple of things that I feel would be great to talk about.\u00a0 The main topic that I want to discuss is SYSPREP.\u00a0 SYSPREP has been a great tool in the virtualized world for","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2010-06-15T21:01:00+00:00","article_modified_time":"2024-01-23T06:50:13+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8562.parkerj_thumb_2B5FBACF.jpg","type":"","width":"","height":""}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SYSPREP in SQL Server 2008 R2","datePublished":"2010-06-15T21:01:00+00:00","dateModified":"2024-01-23T06:50:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/"},"wordCount":470,"commentCount":3,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8562.parkerj_thumb_2B5FBACF.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/","name":"SYSPREP in SQL Server 2008 R2 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8562.parkerj_thumb_2B5FBACF.jpg","datePublished":"2010-06-15T21:01:00+00:00","dateModified":"2024-01-23T06:50:13+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8562.parkerj_thumb_2B5FBACF.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/8562.parkerj_thumb_2B5FBACF.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/06\/15\/sysprep-in-sql-server-2008-r2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SYSPREP in SQL Server 2008 R2"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/5033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=5033"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/5033\/revisions"}],"predecessor-version":[{"id":49988,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/5033\/revisions\/49988"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=5033"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=5033"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=5033"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=5033"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=5033"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=5033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}