{"id":519,"date":"2009-06-12T08:44:00","date_gmt":"2009-06-12T08:44:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/"},"modified":"2009-06-12T08:44:00","modified_gmt":"2009-06-12T08:44:00","slug":"recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/","title":{"rendered":"Recover a portion of list data from a SharePoint Site where only a full SQL Backup or Site Collection Backup Exists"},"content":{"rendered":"<div class=\"ExternalClassFAABD3297ABB4A57A38FDE1EE90172A8\">\n<p>First off, don&#8217;t forget to check the good ole recycle bin and the 2<sup>nd<\/sup> stage recycle bin, when attempting to restore some list data, that may be all you need. But if that data is gone, and you aren&#8217;t using 3<sup>rd<\/sup> party tools like AvePoint, Idera, etc. that give you *granular* restore capabilities, you may find yourself in the situation of having to restore to a &#8216;2<sup>nd<\/sup> Web Application\/Site Collection&#8217;, extracting the data and then bringing it back into your production SharePoint site. <\/p>\n<p>\u00a0<\/p>\n<p>The rest of this blog entry is based on a question I got today and being the lazy blogger I am, I&#8217;m going to share that same response here. <\/p>\n<p>\u00a0<\/p>\n<p><span><strong>Title<\/strong>: how to restore a &#8220;portion&#8221; of SharePoint 2007 MOSS using STSADM <\/span><\/p>\n<p><span style=\"color:#c0504d;font-size:12pt\"><strong>Question<\/strong>: An end user deleted information in an area of SharePoint (2007 MOSS). I know how to do a backup \/ restore of a complete store using STSADM. However, I&#8217;ve never done a restore of a portion of the site&#8230;. What are the steps to do this? <\/span><\/p>\n<p>\u00a0<\/p>\n<h2>I responded with this\u2026 <\/h2>\n<ul>\n<li>What do you have to work with, by way of backups? Site collections? Content Databases, some 3rd party tool? <\/li>\n<li>With fancy 3rd party tools, you&#8217;d use their GUI but I&#8217;m guessing that isn&#8217;t your answer \ud83d\ude42 <\/li>\n<li>If you have SQL Databases, you could create a new web application, attach a copy of a previous content database to it (don&#8217;t overwrite your current one, restore as a different name!), then export the old data, save the list as a template, etc. Whatever method worked best. <\/li>\n<li>If you have a backup of the site collection, you could restore that to an alternate web application (like the steps above) and then extract the bits you need. <\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<h2>They came back with this (just how lazy am I?) <\/h2>\n<p>\u00a0<\/p>\n<p><span style=\"color:#c0504d\">Current backup setup: <\/span><\/p>\n<ul>\n<li><span style=\"color:#c0504d\">Backupexec agent (for sharepoint) <\/span><\/li>\n<li><span style=\"color:#c0504d\">stsadmin.exe (differential every 2hrs and a full first thing every morning) <\/span><\/li>\n<li><span style=\"color:#c0504d\">SQL backup (nightly) <\/span><\/li>\n<\/ul>\n<p><span style=\"color:#c0504d\"><br \/>No easy way to restore like a &#8220;portion&#8221; of a list or site&#8230;  I need to get a third party app&#8230;.. what would you recommend? <\/span><\/p>\n<p>\u00a0<\/p>\n<h1>And finally, I responded with this (hope it is helpful to others) <\/h1>\n<p>\u00a0<\/p>\n<p>I haven&#8217;t used the Backup Exec Agent to restore, but I assume it probably gives you some &#8216;granular&#8217; capabilities if it is any good at all. What are you able to see in there? <\/p>\n<p>\u00a0<\/p>\n<h2>I&#8217;d go with the SQL Nightly backup. <\/h2>\n<p>\u00a0<\/p>\n<ol>\n<li>Create a new Web Application <\/li>\n<li>Create a site collection in it <\/li>\n<li>Remove its Content Database <\/li>\n<li>Restore a copy of the database (from previous night) as a NEW database with a NEW name <\/li>\n<li>Use: stsadm -o addcontentdb -url URL -databasename DatabaseName to attach this database to your new web application <\/li>\n<li>Login to it and see that you can see your old content <\/li>\n<li>Pick whatever method is necessary to get the contents out of there &#8211; I&#8217;ve blogged a number of approaches here: http:\/\/brainlitter.com\/archive\/2009\/04\/04\/sharepoint-list-migration-approaches.aspx <\/li>\n<\/ol>\n<p>\u00a0<\/p>\n<h2>As for recommended 3rd party apps, most of my SMB clients can&#8217;t afford them \ud83d\ude42 <\/h2>\n<p>\u00a0<\/p>\n<ul>\n<li>But AvePoint, Idera, etc. come to mind that have products for that kind of granular backup and recovery. <\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>And one more thing&#8230; Did this user delete a list\/content or a site? If it was a list, or content from it (documents, etc.), you should still be able to find it in their Recycle Bin, and if you can&#8217;t find it there, check the Site (2nd) Recycle Bin, might still be kicking around. Sorry, should have started with that suggestion actually. <\/p>\n<p>\u00a0<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>First off, don&#8217;t forget to check the good ole recycle bin and the 2nd stage recycle bin, when attempting to restore some list data, that may be all you need. But if that data is gone, and you aren&#8217;t using 3rd party tools like AvePoint, Idera, etc. that give you *granular* restore capabilities, you may &hellip; <a href=\"https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/\"><\/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>Recover a portion of list data from a SharePoint Site where only a full SQL Backup or Site Collection Backup Exists - 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\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Recover a portion of list data from a SharePoint Site where only a full SQL Backup or Site Collection Backup Exists - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"First off, don&#8217;t forget to check the good ole recycle bin and the 2nd stage recycle bin, when attempting to restore some list data, that may be all you need. But if that data is gone, and you aren&#8217;t using 3rd party tools like AvePoint, Idera, etc. that give you *granular* restore capabilities, you may &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2009-06-12T08:44: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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/\",\"name\":\"Recover a portion of list data from a SharePoint Site where only a full SQL Backup or Site Collection Backup Exists - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2009-06-12T08:44:00+00:00\",\"dateModified\":\"2009-06-12T08:44:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recover a portion of list data from a SharePoint Site where only a full SQL Backup or Site Collection Backup Exists\"}]},{\"@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":"Recover a portion of list data from a SharePoint Site where only a full SQL Backup or Site Collection Backup Exists - 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\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/","og_locale":"en_US","og_type":"article","og_title":"Recover a portion of list data from a SharePoint Site where only a full SQL Backup or Site Collection Backup Exists - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"First off, don&#8217;t forget to check the good ole recycle bin and the 2nd stage recycle bin, when attempting to restore some list data, that may be all you need. But if that data is gone, and you aren&#8217;t using 3rd party tools like AvePoint, Idera, etc. that give you *granular* restore capabilities, you may &hellip;","og_url":"https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2009-06-12T08:44:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/","url":"https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/","name":"Recover a portion of list data from a SharePoint Site where only a full SQL Backup or Site Collection Backup Exists - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2009-06-12T08:44:00+00:00","dateModified":"2009-06-12T08:44:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/brainlitter\/2009\/06\/12\/recover-a-portion-of-list-data-from-a-sharepoint-site-where-only-a-full-sql-backup-or-site-collection-backup-exists\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"Recover a portion of list data from a SharePoint Site where only a full SQL Backup or Site Collection Backup Exists"}]},{"@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\/519"}],"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=519"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/519\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}