List restore might fail after parent site is restored from SharePoint 2010 SP1 site collection recycle bin
September 20, 2011
SharePoint 2010 Service Pack 1 introduced several exciting features, including the long-waited-for site recycle bin. This allows you to restore a deleted site within 30 days (default setting that can be changed) after deletion. The functionality is available to site collection administrators and can be huge relief for organizations where users tend to spend too much effort on keeping the site hierarchies “neat” and deleting everything that seems to be “not important any more”.
However, there is a gotcha you should be aware of if you rely on this functionality. The issue is already fixed in August 2011 Cumulative Update Package, but I thought I would share the info, since I could not find any KB describing it. Here you go:
Issue. A list cannot be restored from recycle bin after the parent site is deleted and restored from SharePoint SP1 site collection recycle bin.
Details. A list or document library is deleted in a SharePoint 2010 SP1 site and is available in the user recycle bin. The parent site itself is then deleted and appears in the administrator recycle bin on the site collection level. After you restore the site from site collection administrator recycle bin, the deleted list still appears in the user recycle bin, but any attempt to restore the list fails. List contents is unavailable to users.
Steps to reproduce:
- Create a new site in the site collection. For example, the name is New Product Version Team Site: http://MyPortal/sites/MyProduct/NewProductVersion
- Create a document library in the newly created site (Project Specs) and upload several documents.
- Delete the newly created document library. The library appears in the user recycle bin in the New Product Version site.
- Delete the site. The deleted site appears in the site collection recycle bin.
- Restore the site from site collection recycle bin.
- Open the restored site and go to the user recycle bin. The document library appears there as expected.
- Select the document library (Project Specs) and click Restore.
Expected result: The library should be restored from Recycle Bin.
Actual result (on SharePoint 2010 Service Pack 1 without August 2011 Cumulative Update Package): Restore attempt fails with error: “A list with this name “Project Specs” already exists. To restore the list, move or rename the existing list and try again.”
In addition, deleted document library (Project Specs) unexpectedly appears in the “All Site Content” after the site restore. An attempt to open the Project Specs document library from All Site Content page fails with 404 error.
Resolution: Luckily, the SharePoint team already fixed this issue, all you need is obtain and install SharePoint 2010 August 2011 Cumulative Update Package before trying to restore the deleted site. You can find information about August CU here for SharePoint Sever and for SharePoint Foundation. I only posted this issue description for reference, since there seems to be no description of the symptoms in Microsoft Support KB articles.
A SharePoint Saturday on Monday #SPConfRU
June 23, 2011
It was a very pleasant and unusual experience for me this week to speak at the SharePoint Conference Russia – 2011. The conference was awesome and the crowd was much more interested in SharePoint than I was expecting. My session was the last before conference wrap up, and we stayed for almost half hour after the session for Q&A! The biggest challenge for me – surprisingly – was to keep speaking Russian, and not switch to English completely when using all the SharePoint terminology.
Having been to a number of different industry events in the US and Europe before, I cannot help comparing this conference to some of those. As far as I can tell, SharePoint Conference Russia is very close to the SharePoint Saturdays. The event is completely driven by community, in this case – Russian SharePoint User Group, and it is completely free to attend. (Thanks to the sponsors, and I am happy that my employer participated as the sponsor as well!)
- SPConfRu had simultaneous live stream online from all 3 concurrent sessions. Never seen this at any other SharePoint event really.
- The food was absolutely awesome :-) I’m not complaining about the food at other events, but here it was way better than one can expect to get a free event.
- Unlike other SharePoint Saturdays, good part of the attendees were seriously looking people in good suits – IT directors and CIO’s, not a typical attendee for a free event. I think this shows there is a lack of (and the need for) SharePoint-centric events targeted more at the business users and IT decision makers in Russia. There are no SPTechCon or SharePoint Best Practices here.
- Finally, the event was on Monday – so they had to call it SharePoint Conference instead of SharePoint Saturday :-)
So once again I’d like to say thank you to the SPConfRU organizers – Oksana and the team did absolutely great job, and I really look forward to more events from the user group in Russia.
BTW, here’re the slides from my “Planning SharePoint 2010 backup and recovery – where do I start?” session
New Home for Quest SharePoint Community
November 10, 2010
Just a quick post for those of you who have been following the Quest SharePoint For All community. We have moved the site to Quest Communities home and it is now available at http://communities.quest.com/community/sharepointforall.
I just posted my first blog entry there, a brief look back at the evolution of SharePoint administration and the challenges Quest Site Administrator has been helping to address since its first release in 2006.
So come join Quest experts, get insights from the product teams, connect with other users and the developers of Quest SharePoint products! And don’t forget to update your blog rolls and RSS feeds.
Cannot find document in SharePoint Recycle Bin?
March 19, 2010
Ever searched for a document or list item in SharePoint 2007 Recycle Bin with no luck? You know the document was deleted from the SharePoint site, so why does it not show up here? Here’re possible reasons for that:
- Are you looking at the correct site? Recycle Bin in SharePoint is site-specific, a document deleted from http://myportal/sites/projects/manhattan will not appear in the top level site’s (http://myportal/sites/projects) Recycle Bin.
- Were it you who deleted the document? Recycle Bin is not only site-specific, it is also specific for each user. Thus the Recycle Bin contents you see is limited to documents, items, lists and libraries that you’ve deleted, content deleted by other users does not show up here.
- How long ago was it deleted? Recycle Bin does not keep deleted items for ever. The default setting in SharePoint is to keep content in Recycle Bin for 30 days after deletion, this can be changed by the SharePoint farm administrators. When this grace period is over, items are moved to the second stage aka Site Collection Recycle Bin.
If any of the above seems to be the likely reason, the Site Collection Recycle Bin can help. To access this, you should have the site collection administrator privileges. Site Collection Recycle Bin shows all the deleted content from all sub-sites within this site collection, regardless of who deleted this data. By default it keeps the data for the same period after it was moved from the first stage Recycle Bin, or until it reaches certain percentage of the site collection’s quota.
Still there can be situations when a deleted item/document does not appear in both site and site collection Recycle Bins. The most common is when a folder or entire list or library is deleted. Recycle Bin only shows the object that has been deleted, with no ability to expand or search its contents. When looking for a document make sure you consider that possibly its parent folder or library can be showing up in the Recycle Bin instead.
Finally, there are site deletes, which are not captured by the Recycle Bin. If this is a common situation in your SharePoint, you might want to extend your deployment with the MSIT Site Delete Capture tool (available at http://governance.codeplex.com/releases/view/3830), or looks for 3rd party granular recovery tools.
Same applies to SharePoint 2007 as well as 2010, there are no changes in how you work with the Recycle Bin in SharePoint 2010.
Some useful links and resources for planning and using the Recycle Bin in SharePoint:
- For business users: View, restore, or delete items in the Recycle Bin article on SharePoint help and how-to site (http://office.microsoft.com/en-us/sharepointtechnology/HA100214341033.aspx)
- For IT admins: Plan for capturing and storing deleted objects on TechNet (http://technet.microsoft.com/en-us/library/cc262975.aspx)
- For PowerShell geeks: Restoring from SharePoint 2010 Recycle Bin through PowerShell (http://maplpro.blogspot.com/2010/03/how-to-restore-from-sharepoint-2010.html)
Technorati Tags:
SharePoint, recycle bin, SharePoint 2010
Just saw this link on Mauro Cordelli’s blog: http://sharepoint.microsoft.com/2010/Sneak_Peek/Pages/default.aspx
Make sure to check this out! The site includes short video overviews of what’s new for the users, for IT pros and for developers; preliminary system requirements and advice on how to get ready; and preliminary availability dates:
Beta in 2009, general availability targeted at the first half of 2010.
Speaking about how to get ready, make sure to read Joel’s recent post on the stsadm.exe -o preupgradecheck. This command is available in stsadm.exe as of Service Pack 2 for WSS v3 and MOSS 2007, and is the first planning step on your path to the future upgrade.
If you’re interested in getting more info about SharePoint 2010, sign up for the SharePoint conference in October. Detailed agenda is not yet published for the event, but looks like there will be a healthy mix of sessions on getting most from the current versions as well as learning about the futures. See you there!
UPDATE (7/28): I also posted some thoughts around backup and recovery in SharePoint 2010 and specifically the new unattached content database feature on the SharePoint For All site.
Technorati Tags:
sharepoint, sharepoint 2010, sharepoint conference
Update on “Cannot find… exportsettings.xml” error when restoring site with SharePoint Designer. Go get SP2.
May 13, 2009
Remember the “Cannot find… exportsettings.xml” error when trying to restore a site with SharePoint Designer? The reason for the error was the default 25MB file size limitation for the CMP files used to store the backup.
If you tried to use SharePoint Designer for site backup and ran into this error, you just have another reason to upgrade your SharePoint farm to Service Pack 2. Why? Here’s what the TechNet article on SharePoint Designer site backup says:
If you have not installed Windows SharePoint Services 3.0 with Service Pack 2 (SP2), backups that are performed by using Office SharePoint Designer are limited to 25 megabytes (MB). After you install Windows SharePoint Services 3.0 with SP2, the limit is increased to 2 gigabytes (GB).
For sites larger than 2GB the same workaround still applies, you can get the rest of your backup from the Site Collection Recycle Bin and manually reconcile it.
Thanks to Alex Kirillov who brought my attention to this change in WSS v3 SP2.
Technorati Tags:
sharepoint, backup, SharePoint Designer
Book Giveaway: SharePoint 2007 Disaster Recovery Guide
April 7, 2009
As promised last week, we’re giving away three copies of SharePoint 2007 Disaster Recovery Guide, a book by John Ferringer and Sean McDonough.
If you’re following my blog, you already know about the new SharePoint community we (Quest Software) have launched at www.SharePointForAll.com. So I want to try and use this opportunity to bring more good people to the community.
To win your free copy of the book, you need to:
- Join the SharePoint For All community if you’re not a registered member yet. It’s very simple, but gives you access to the forums and downloads on the site. Downloads include pre-release Beta versions of Quest management and migration tools for SharePoint, as well as freeware tools such as SharePoint Disaster Recovery Advisor.
- Publish a link to SharePoint for all site on your SharePoint-related blog or on a publicly available SharePoint-related forum. It can be a link to the site’s home page, or any of the downloads, or any blog post on the Quest team blog, whatever is more relevant to the topic of your post.
- Finally, send an email with the two links to a special email address: get-a-book@sharepoint-recovery.com. Your email should include links to your profile at SharePointForAll.com community site and to your blog/forum post, and your name/contact info.
The first three winners will get the free copy of SharePoint 2007 Disaster Recovery Guide. You can see my review of the book here, and read more about it on Amazon.com.
One more note, you cannot win the book if you work for Quest. Sorry, guys – I can lend you my copy if you want to read it :-)
Once again, many thanks to the publisher, Cengage Learning, for giving me this opportunity.
Technorati Tags:
book review, community, disaster recovery, Quest, SharePoint
You must have seen it on a number of blogs already, starting with Mark Rackley’s “SharePoint Designer – a definite maybe” post last Sunday: SharePoint Designer is now free for anyone to download and use. See official details from Microsoft and the download link in a Letter to SharePoint Designer customers.
Well… Enough said by Marc and in Joel’s response: I highly recommend reading both posts. Although they seem to disagree on some details, bottom line of both posts is the same: SharePoint Designer is a powerful and very handy tool if you know what you’re doing. Otherwise it can be disastrous. So… if you don’t lock down SPD use in your farms, make sure you have a good backup before your users start playing with it!
Technorati Tags:
MOSS 2007, sharepoint, sharepoint administration, sharepoint designer
Book Review: SharePoint 2007 Disaster Recovery Guide
April 1, 2009
Nice people from Cengage Learning contacted me recently for a review of a book they published. The book is called SharePoint 2007 Disaster Recovery Guide and was written by John L. Ferringer and Sean McDonough.
They were also very kind to send me three copies of the book for giveaway, but since you won’t believe it on April 1st anyway ;-) there’ll be a separate post soon explaining how to win your copy.
Who should read this book?
This book will be invaluable for SharePoint administrators who already have a good understanding of how data is stored in SharePoint and have some technical experience with built-in backup and recovery tools. I think it would be a difficult read for those who only have end user experience with SharePoint and are new to the platform administration. It will be overwhelming and confusing for such readers.
Why read this book?
I think that anyone who already has such experience and is tasked with preparing an overall disaster recovery plan should read this. Here’s the good stuff you will find in the book:
- Helpful tips on what you can do with the native backup and recovery tools and how you could extend them via scripting and custom development can be found troughout the book, specifically in chapters 6-7.
- If you are SharePoint administrator with not much experience in technologies it depends on, such as IIS and SQL Server, you’ll find quite a few insights here and get a bigger picture of what tools exist and can be used in SharePoint disaster recovery. Chapters 8 through 11 cover SQL server and Windows backup and recovery and high availability.
- Real jewels in chapters 12 through 14 (DR Planning and Key Concepts; Design and Implementation; Testing and Maintenance) are a must-read for any technical staff responsible for SharePoint recovery. Too often we think of SharePoint just from technical perspective, these chapters help to put the technology in the right place from perspective of the overall business continuity planning.
Some suggestions for the Second Edition
Few things that I believe could be done better to make the book more straightforward for SharePoint newbies, not only administrators with good level of understanding:
- Add an overview of how SharePoint data, configurations, and customizations are stored. A lot of this information is scattered throughout the book, but there’s no single chapter in the book to serve as a reference. Things like Joel’s SharePoint containment hierarchy could really help here.
- Make it very clear how much technical knowledge and experience is assumed. Some sections of the book surprised me by too detailed explanations of the basics (like the default install paths with screenshots, etc.), while the very next page can mention about IP bindingsin IIS with no explanation at all.
- Re-write or cut the chapters that cover topics that are not directly related to disaster recovery. It’s good to know about recycle bins, SharePoint Designer backups, and maybe even the options such as saving site templates with content. But none of these really fits into the disaster recovery plan discussed further on in the book, and spending almost 60 pages on them might be too much.
- Get another round of technical review to ensure all technical details are accurate and there is no ambiguity. For example, in several places the book mentions you can restore a single site collection from a Central Administration backup. In reality, this is only true when you keep one site collection per content database. This assumption is never articulated in the book, which can be really misleading for readers who don’t have hands-on experience with Central Administration and STSADM.exe backups.
Bottom line:
SharePoint 2007 Disaster Recovery Guide is a great resource for SharePoint administrators with good technical understanding of SharePoint overall architecture and built-in backup and recovery tools. From reading it you can learn how you can extend the use of the native tools with other methods, and see what other technologies such as Windows Server and SQL Server have to offer. Finally, the book allows you to take a step back and see the bigger picture of SharePoint disaster recovery from the business perspective.
So, take your time to review the ToC with John’s comments and stay tuned for the giveaway details!
Technorati tags:
book review; disaster recovery; sharepoint; sql; stsadm.exe
When you start planning for disaster recovery of your SharePoint farm you inevitably face the challenge of how to restore the farm configuration.
What is a configuration database? A configuration database in SharePoint is what defines your farm. It keeps all the information about other databases, servers and services that comprise the farm. It also stores info about “all Internet Information Services (IIS) Web sites or Web applications, solutions, Web Part packages, site templates, and Web application and farm settings specific to SharePoint technologies, such as default quota, blocked file types, and configuration” (from Database types and descriptions). If you want to drill into this in more detail, take a look at the database structure explained in Nidhi’s blog.
The coolest thing about configuration database in my opinion is how it serves as a central piece in WSS 3.0 architecture to allow administrators easily scale a SharePoint farm. All the global farm settings, most of IIS configuration (some details in Joel’s post here), and even solution binaries are stored in the config database and will be automatically propagated from there when you join more servers to the farm.
What’s the problem with backup/recovery of configuration database? Restoration of SharePoint configuration database is not supported by Microsoft if all you do is just take farm backup via Central Administration or with STSADM. In case of disaster recovery, you would have to manually re-create all farm settings, re-deploy any solutions and customizations, etc. A related article on TechNet gives a little insight on what causes this support limitation:
Although the configuration database and the SharePoint Central Administration Web site content database can be backed up, restoring backups of the configuration database and Central Administration content database from a farm by using the tools built in to SharePoint Products and Technologies is not supported.
This is because data in these databases may not be synchronized with data in other Microsoft Office SharePoint Server 2007 databases. Therefore, the tools built in to SharePoint Products and Technologies do not recover these databases during a farm-level recovery.
If this data is not synchronized, users might experience various random errors.
So, is there any way I can back up and restore the config database? We were discussing this with a well-known SQL expert Charley Hanania a while ago, and came to a simple thought – if something can be backed up, it must be possible to restore it. It’s the question of understanding the risks and choosing the right tools to mitigate them. If the risk is that SharePoint farm structure information in config database would be not synchronized with other databases, you need a way to make a point-in-time backup of all databases within the farm, ensuring that none of these databases changes during the backup process. How is this possible?
- Obviously, snapshot technologies and products that use them can achieve this functionality. For example, this allows Microsoft Data Protection Manager to back up and restore all SharePoint databases, including configuration db.
- Another supported way to restore all databases suggested on TechNet is to take a backup when the SharePoint farm is offline. Essentially, this means all SharePoint services are stopped across all front end and application servers, and no changes are being made during the backup process. Does not seem feasible for live SharePoint environment? This is where SQL Server’s features such as log shipping or database mirroring can help. Both techniques allow you to create and maintain a copy of SQL database that is not accessed by SharePoint. So working closely with your SQL DBA you can have a “point-in-time” copy of all the farm databases and back them up.
Config db is not the only reason why you can utilize log shipping and/or database mirroring in SharePoint environment. For example, see Mike Watson’s recent presentation decks from Best Practices and SPTech conferences, where he discusses how both options apply to SharePoint environment for high availability and disaster recovery.
Technorati tags:
Data Protection Manager; DPM; disaster recovery; SharePoint; SQL
