{"id":260,"date":"2008-04-15T21:15:49","date_gmt":"2008-04-15T21:15:49","guid":{"rendered":"http:\/\/parkesy.wordpress.com\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/"},"modified":"2008-04-15T21:15:49","modified_gmt":"2008-04-15T21:15:49","slug":"restore-a-list-or-library-in-wss-v2","status":"publish","type":"post","link":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/","title":{"rendered":"Restore a list or library in WSS v2"},"content":{"rendered":"

This might be a pretty obvious tip but hopefully it will help someone!<\/p>\n

The version of SharePoint that comes with SBS is a little unforgiving if you delete something. Out of the box there is no recycle bin so if something is gone it’s gone.<\/p>\n

On the backup section of there is document (also available here<\/a>) that explains how to setup the following command as a scheduled task to backup the sharepoint on a daily basis (you are doing this? right?)<\/p>\n

\n

“%SystemDrive%\\Program files\\Common files\\Microsoft shared\\Web server extensions\\60\\Bin\\Stsadm.exe” -o backup -url http:\/\/Companyweb -filename target path -overwrite
<\/strong><\/p>\n

Where target path <\/i>is where you save the backup of your internal Web site. You must type the quotation marks. <\/p>\n<\/blockquote>\n

I’ve wrapped this in a vbscript to give me five days worth of backups, just in case and i’ll post this another time<\/em><\/p>\n

The idea then is if you need to retrieve a document or a list item you restore the whole site to a temporary location and copy back what you need using this command<\/p>\n

\n

“%SystemDrive%\\Program files\\Common files\\Microsoft shared\\Web server extensions\\60\\Bin\\Stsadm.exe” -o createsiteinnewdb -url http:\/\/companyweb\/sites\/RestoredSite -ownerlogin DOMAIN<\/i>\\administrator -ownere-mail administrator@DOMAIN.local <\/i>-databasename STS_RESTORE<\/strong><\/p>\n

<\/strong>where DOMAIN <\/i>is your server domain and administrator@DOMAIN.local <\/i>is your administrator’s e-mail address. <\/p>\n<\/blockquote>\n

Once your finished you tidy up after yourself by deleting the restored site using Sharepoint central administration and deleting the SQL database (the exact details for this are in the document i mentioned above)<\/p>\n

I did this last week and it’s a pretty straightforward thing to do<\/p>\n

However my client wasn’t after a specific document or list item. They were after the whole thing as they had “accidentally” deleted an important list<\/p>\n

Once i’d restored the site i initially thought i’d have to re-create the list by hand, adding all the columns and the views then copy the items back<\/p>\n

I thought there had to be an easier way and this what i did<\/p>\n

Go to the restored version of the list (or library) and click “Modify settings and columns”<\/em><\/p>\n

Then click the “save as a template” <\/em>option. Enter a filename and title and most importantly ensure the “include content” <\/em>checkbox is checked and click OK. This saves the template to the site templates gallery<\/p>\n

Then click on the “Site Settings” <\/em>option, then “Go to Site Administration”<\/em> and finally “Manage list template gallery”. <\/em><\/p>\n

In here you will see your saved item. Click on the file name and save the STP file to file location of your choosing<\/p>\n

Go to the production site and repeat the steps to get into the List Template Gallery.<\/p>\n

From here you can now upload the saved STP file<\/p>\n

The click on the CREATE item at the top and you will see you can create a new list based on your restored item. <\/p>\n

Once created everything will be back in place including all the content inside! (I’m guessing security will need to reset by hand if it originally didn’t inherit from the site)<\/p>\n

You can then delete the list template as it’s not needed<\/p>\n

VOILA!<\/p>\n

As i said from the start on reflection this seemed pretty obvious but in the past i’ve done plenty of things that seemed obvious only for them to turn up in another blog a couple of days later so hopefully someone will get some use from this!<\/p>\n","protected":false},"excerpt":{"rendered":"

This might be a pretty obvious tip but hopefully it will help someone! The version of SharePoint that comes with SBS is a little unforgiving if you delete something. Out of the box there is no recycle bin so if something is gone it’s gone. On the backup section of there is document (also available<\/p>\n

<\/span>Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[45],"tags":[],"class_list":["post-260","post","type-post","status-publish","format-standard","hentry","category-sharepoint"],"yoast_head":"\nRestore a list or library in WSS v2 - Andy's Techie 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:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Restore a list or library in WSS v2 - Andy's Techie Blog\" \/>\n<meta property=\"og:description\" content=\"This might be a pretty obvious tip but hopefully it will help someone! The version of SharePoint that comes with SBS is a little unforgiving if you delete something. Out of the box there is no recycle bin so if something is gone it’s gone. On the backup section of there is document (also availableRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/\" \/>\n<meta property=\"og:site_name\" content=\"Andy's Techie Blog\" \/>\n<meta property=\"article:published_time\" content=\"2008-04-15T21:15:49+00:00\" \/>\n<meta name=\"author\" content=\"Andy Parkes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andy Parkes\" \/>\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:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/\",\"url\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/\",\"name\":\"Restore a list or library in WSS v2 - Andy's Techie Blog\",\"isPartOf\":{\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#website\"},\"datePublished\":\"2008-04-15T21:15:49+00:00\",\"dateModified\":\"2008-04-15T21:15:49+00:00\",\"author\":{\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/3534e8ac6b1bec765cd061feff56679d\"},\"breadcrumb\":{\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/andyparkes.co.uk\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Restore a list or library in WSS v2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#website\",\"url\":\"https:\/\/andyparkes.co.uk\/blog\/\",\"name\":\"Andy's Techie Blog\",\"description\":\"Professional Geek\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/andyparkes.co.uk\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/3534e8ac6b1bec765cd061feff56679d\",\"name\":\"Andy Parkes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3824cbf53df51d7ca5cf809b6ad81a157fbfff2292e36ab8666f04ddad06bfcc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3824cbf53df51d7ca5cf809b6ad81a157fbfff2292e36ab8666f04ddad06bfcc?s=96&d=mm&r=g\",\"caption\":\"Andy Parkes\"},\"description\":\"Andy Parkes is Technical Director at Coventry based IT support company IBIT Solutions. Formerly, coordinator of AMITPRO and Microsoft Partner Area Lead for 2012-2013. He also isn't a fan of describing himself in the third person.\",\"sameAs\":[\"http:\/\/www.andyparkes.co.uk\/blog\"],\"url\":\"https:\/\/andyparkes.co.uk\/blog\/index.php\/author\/andyparkes\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Restore a list or library in WSS v2 - Andy's Techie 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:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/","og_locale":"en_US","og_type":"article","og_title":"Restore a list or library in WSS v2 - Andy's Techie Blog","og_description":"This might be a pretty obvious tip but hopefully it will help someone! The version of SharePoint that comes with SBS is a little unforgiving if you delete something. Out of the box there is no recycle bin so if something is gone it’s gone. On the backup section of there is document (also availableRead More","og_url":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/","og_site_name":"Andy's Techie Blog","article_published_time":"2008-04-15T21:15:49+00:00","author":"Andy Parkes","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Andy Parkes","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/","url":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/","name":"Restore a list or library in WSS v2 - Andy's Techie Blog","isPartOf":{"@id":"https:\/\/andyparkes.co.uk\/blog\/#website"},"datePublished":"2008-04-15T21:15:49+00:00","dateModified":"2008-04-15T21:15:49+00:00","author":{"@id":"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/3534e8ac6b1bec765cd061feff56679d"},"breadcrumb":{"@id":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/andyparkes.co.uk\/blog\/index.php\/2008\/04\/15\/restore-a-list-or-library-in-wss-v2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/andyparkes.co.uk\/blog\/"},{"@type":"ListItem","position":2,"name":"Restore a list or library in WSS v2"}]},{"@type":"WebSite","@id":"https:\/\/andyparkes.co.uk\/blog\/#website","url":"https:\/\/andyparkes.co.uk\/blog\/","name":"Andy's Techie Blog","description":"Professional Geek","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/andyparkes.co.uk\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/3534e8ac6b1bec765cd061feff56679d","name":"Andy Parkes","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/andyparkes.co.uk\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3824cbf53df51d7ca5cf809b6ad81a157fbfff2292e36ab8666f04ddad06bfcc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3824cbf53df51d7ca5cf809b6ad81a157fbfff2292e36ab8666f04ddad06bfcc?s=96&d=mm&r=g","caption":"Andy Parkes"},"description":"Andy Parkes is Technical Director at Coventry based IT support company IBIT Solutions. Formerly, coordinator of AMITPRO and Microsoft Partner Area Lead for 2012-2013. He also isn't a fan of describing himself in the third person.","sameAs":["http:\/\/www.andyparkes.co.uk\/blog"],"url":"https:\/\/andyparkes.co.uk\/blog\/index.php\/author\/andyparkes\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pmvJ6-4c","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=260"}],"version-history":[{"count":0,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/260\/revisions"}],"wp:attachment":[{"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andyparkes.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}