{"id":62,"date":"2008-10-23T23:08:00","date_gmt":"2008-10-23T23:08:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/"},"modified":"2008-10-23T23:08:00","modified_gmt":"2008-10-23T23:08:00","slug":"production-sharepoint-site-to-sandbox-overwrite-refresh-steps","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/","title":{"rendered":"Production SharePoint Site to Sandbox Overwrite\/Refresh Steps"},"content":{"rendered":"<div class=\"ExternalClass34758494411F4237A408960F87B8ED92\">\n<p>I believe firmly that if you are going to *play* in SharePoint, you should play in a sandbox, and ideally, with production *like* data.\u00a0 To accomplish this for clients, I generally provide a &#8216;sandbox&#8217; site, in addition to their production WSS site.<\/p>\n<p>\u00a0<\/p>\n<p>So, for example, if a client had a portal at <a>https:\/\/portal.mycompany.com<\/a>, I&#8217;d likely have a &#8216;sandbox&#8217; for them at <a href=\"http:\/\/sandbox.mycompany.com\/\">http:\/\/sandbox.mycompany.com<\/a>. Then, on request or occasion, I&#8217;d *refresh* the sandbox with the latest version of their production site (and I&#8217;d also then change the colour theme to something that really stands out &#8211; i.e. ugly &#8211; so it is clear they are not manipulating their production data).<\/p>\n<p>\u00a0<\/p>\n<p>Based on the outline above, this is how the refresh would be handled&#8230;<\/p>\n<div style=\"border-right:gray 1px solid;padding-right:4px;border-top:gray 1px solid;padding-left:4px;font-size:8pt;padding-bottom:4px;margin:20px 0px 10px;overflow:auto;border-left:gray 1px solid;width:97.5%;cursor:text;line-height:12pt;padding-top:4px;border-bottom:gray 1px solid;font-family:consolas, 'Courier New', courier, monospace;background-color:#f4f4f4\">\n<div style=\"padding-right:0px;padding-left:0px;font-size:8pt;padding-bottom:0px;overflow:visible;width:100%;color:black;border-top-style:none;line-height:12pt;padding-top:0px;font-family:consolas, 'Courier New', courier, monospace;border-right-style:none;border-left-style:none;background-color:#f4f4f4;border-bottom-style:none\">\n<pre style=\"padding-right:0px;padding-left:0px;font-size:8pt;padding-bottom:0px;margin:0em;overflow:visible;width:100%;color:black;border-top-style:none;line-height:12pt;padding-top:0px;font-family:consolas, 'Courier New', courier, monospace;border-right-style:none;border-left-style:none;background-color:white;border-bottom-style:none\"><span style=\"color:#606060\">   1:<\/span> cd %COMMONPROGRAMFILES%Microsoft sharedWeb server extensions12Bin<\/pre>\n<pre style=\"padding-right:0px;padding-left:0px;font-size:8pt;padding-bottom:0px;margin:0em;overflow:visible;width:100%;color:black;border-top-style:none;line-height:12pt;padding-top:0px;font-family:consolas, 'Courier New', courier, monospace;border-right-style:none;border-left-style:none;background-color:#f4f4f4;border-bottom-style:none\"><span style=\"color:#606060\">   2:<\/span>\u00a0 <\/pre>\n<pre style=\"padding-right:0px;padding-left:0px;font-size:8pt;padding-bottom:0px;margin:0em;overflow:visible;width:100%;color:black;border-top-style:none;line-height:12pt;padding-top:0px;font-family:consolas, 'Courier New', courier, monospace;border-right-style:none;border-left-style:none;background-color:white;border-bottom-style:none\"><span style=\"color:#606060\">   3:<\/span> REM Back it up...<\/pre>\n<pre style=\"padding-right:0px;padding-left:0px;font-size:8pt;padding-bottom:0px;margin:0em;overflow:visible;width:100%;color:black;border-top-style:none;line-height:12pt;padding-top:0px;font-family:consolas, 'Courier New', courier, monospace;border-right-style:none;border-left-style:none;background-color:#f4f4f4;border-bottom-style:none\"><span style=\"color:#606060\">   4:<\/span> stsadm -o backup -url https:<span style=\"color:#008000\">\/\/portal.mycompany.com:443 -filename \"D:TOPportal2sandboxswapportalbackup.bak\"<\/span><\/pre>\n<pre style=\"padding-right:0px;padding-left:0px;font-size:8pt;padding-bottom:0px;margin:0em;overflow:visible;width:100%;color:black;border-top-style:none;line-height:12pt;padding-top:0px;font-family:consolas, 'Courier New', courier, monospace;border-right-style:none;border-left-style:none;background-color:white;border-bottom-style:none\"><span style=\"color:#606060\">   5:<\/span>\u00a0 <\/pre>\n<pre style=\"padding-right:0px;padding-left:0px;font-size:8pt;padding-bottom:0px;margin:0em;overflow:visible;width:100%;color:black;border-top-style:none;line-height:12pt;padding-top:0px;font-family:consolas, 'Courier New', courier, monospace;border-right-style:none;border-left-style:none;background-color:#f4f4f4;border-bottom-style:none\"><span style=\"color:#606060\">   6:<\/span> REM Restore it to sandbox...<\/pre>\n<pre style=\"padding-right:0px;padding-left:0px;font-size:8pt;padding-bottom:0px;margin:0em;overflow:visible;width:100%;color:black;border-top-style:none;line-height:12pt;padding-top:0px;font-family:consolas, 'Courier New', courier, monospace;border-right-style:none;border-left-style:none;background-color:white;border-bottom-style:none\"><span style=\"color:#606060\">   7:<\/span> stsadm -o restore -url http:<span style=\"color:#008000\">\/\/sandbox.mycompany.com:80 -overwrite -filename \"D:TOPportal2sandboxswapportalbackup.bak\"<\/span><\/pre>\n<pre style=\"padding-right:0px;padding-left:0px;font-size:8pt;padding-bottom:0px;margin:0em;overflow:visible;width:100%;color:black;border-top-style:none;line-height:12pt;padding-top:0px;font-family:consolas, 'Courier New', courier, monospace;border-right-style:none;border-left-style:none;background-color:#f4f4f4;border-bottom-style:none\"><span style=\"color:#606060\">   8:<\/span>\u00a0 <\/pre>\n<pre style=\"padding-right:0px;padding-left:0px;font-size:8pt;padding-bottom:0px;margin:0em;overflow:visible;width:100%;color:black;border-top-style:none;line-height:12pt;padding-top:0px;font-family:consolas, 'Courier New', courier, monospace;border-right-style:none;border-left-style:none;background-color:white;border-bottom-style:none\"><span style=\"color:#606060\">   9:<\/span> REM Reset IIS 'cause I like to...<\/pre>\n<pre style=\"padding-right:0px;padding-left:0px;font-size:8pt;padding-bottom:0px;margin:0em;overflow:visible;width:100%;color:black;border-top-style:none;line-height:12pt;padding-top:0px;font-family:consolas, 'Courier New', courier, monospace;border-right-style:none;border-left-style:none;background-color:#f4f4f4;border-bottom-style:none\"><span style=\"color:#606060\">  10:<\/span> IISRESET<\/pre>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>I believe firmly that if you are going to *play* in SharePoint, you should play in a sandbox, and ideally, with production *like* data.\u00a0 To accomplish this for clients, I generally provide a &#8216;sandbox&#8217; site, in addition to their production WSS site. \u00a0 So, for example, if a client had a portal at https:\/\/portal.mycompany.com, I&#8217;d &hellip; <a href=\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/\"><\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[337,14,339],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Production SharePoint Site to Sandbox Overwrite\/Refresh Steps - Brainlitter - Inside the mind of Sean Wallbridge<\/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:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Production SharePoint Site to Sandbox Overwrite\/Refresh Steps - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"I believe firmly that if you are going to *play* in SharePoint, you should play in a sandbox, and ideally, with production *like* data.\u00a0 To accomplish this for clients, I generally provide a &#8216;sandbox&#8217; site, in addition to their production WSS site. \u00a0 So, for example, if a client had a portal at https:\/\/portal.mycompany.com, I&#8217;d &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2008-10-23T23:08:00+00:00\" \/>\n<meta name=\"author\" content=\"Sean Wallbridge\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sean Wallbridge\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/\",\"name\":\"Production SharePoint Site to Sandbox Overwrite\/Refresh Steps - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2008-10-23T23:08:00+00:00\",\"dateModified\":\"2008-10-23T23:08:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Production SharePoint Site to Sandbox Overwrite\/Refresh Steps\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/\",\"name\":\"Brainlitter - Inside the mind of Sean Wallbridge\",\"description\":\"Dad. Husband. Drummer. Learner of Things.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\",\"name\":\"Sean Wallbridge\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"caption\":\"Sean Wallbridge\"},\"url\":\"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Production SharePoint Site to Sandbox Overwrite\/Refresh Steps - Brainlitter - Inside the mind of Sean Wallbridge","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:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/","og_locale":"en_US","og_type":"article","og_title":"Production SharePoint Site to Sandbox Overwrite\/Refresh Steps - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"I believe firmly that if you are going to *play* in SharePoint, you should play in a sandbox, and ideally, with production *like* data.\u00a0 To accomplish this for clients, I generally provide a &#8216;sandbox&#8217; site, in addition to their production WSS site. \u00a0 So, for example, if a client had a portal at https:\/\/portal.mycompany.com, I&#8217;d &hellip;","og_url":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2008-10-23T23:08:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/","url":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/","name":"Production SharePoint Site to Sandbox Overwrite\/Refresh Steps - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2008-10-23T23:08:00+00:00","dateModified":"2008-10-23T23:08:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/brainlitter\/2008\/10\/23\/production-sharepoint-site-to-sandbox-overwrite-refresh-steps\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"Production SharePoint Site to Sandbox Overwrite\/Refresh Steps"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/brainlitter\/#website","url":"https:\/\/regroove.ca\/brainlitter\/","name":"Brainlitter - Inside the mind of Sean Wallbridge","description":"Dad. Husband. Drummer. Learner of Things.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77","name":"Sean Wallbridge","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","caption":"Sean Wallbridge"},"url":"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/62"}],"collection":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/comments?post=62"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/62\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}