Someone added an interesting comment to the announcement of my “Backup and recovery planning 101″ session at SharePoint Conference Ukraine. The guy said they had a problem recently when a SharePoint restore did not work. So the comment was “backups don’t save you from trouble“, and I think it’s worth looking into in more detail. Here’s the situation as it was described:
- Several designers are working on a custom application in production SharePoint
- One of them leaves the desk with a bunch of unsaved changes on screen
- At the same time, another member of the team makes edits and removes “unnecessary” roles (permission levels)
- The first designer comes back and saves objects that are dependent on no longer existing permission levels
Well… of course backups don’t save you from trouble when you did everything to get into that trouble! Here’re my 5 tips that could have helped to avoid the failure – and most of this is not about backups:
- Never develop or test an application in your live production system. If you think you do not have a test environment, you are wrong – you do have a test SharePoint farm. It’s just by mistake you call it your production.
- Define roles and responsibilities. These two designers making simultaneous changes to the same app could have probably better split their work to mitigate risks and dependencies.
- Implement change control processes. With a proper change control in place, all team members would have reviewed and signed off on all of the suggested changes before anyone started editing anything.
- Assess different SharePoint failure scenarios and their business impact, ranging from entire farm disaster recovery down to a single item recovery. How critical is the failure on each of these levels for the business processes? What happens if all SharePoint services become unavailable? How much data your business can afford to lose?
- Develop and implement backup and recovery plan based on these findings. Establish a practice for testing backups and performing fire drill recoveries to ensure the plan continues to work as the SharePoint environment evolves.
What we have here is an example of extremely poor SharePoint governance. As much as the term itself may be confusing, the lack of governance is usually obvious. See this great post by Susan Hanley for a broader discussion of governance and guidance.
A proper backup and recovery plan is designed to minimize the business impact in case of data loss or service unavailability, based on the estimated scale of this impact. However, backups are only a part of the organization’s efforts to ensure business continuity. Having a backup in place cannot be an excuse for ignoring the need to properly govern your SharePoint customization and deployment.
March 27, 2012
Just got another question about SharePoint 2010 remote BLOB storage (RBS) and its impact on the backups. The topic is already covered by so many posts and articles, I will just add a quick summary and few links to more details.
There are three simple things to remember about RBS and backups:
- It is the RBS provider implementation that defines how backup works for externalized content. External content may or may not be included in your backups, depending on the provider you choose.
- With the out of the box SQL 2008 R2 RBS FILESTREAM provider, externalized content is included in traditional VDI backups (“virtual backup device interface”). That is, native SQL and SharePoint backups will include both the database and the external content. Same is true for all 3rd party SQL backups that use VDI.
- The out of the box SQL 2008 R2 RBS FILESTREAM provider does not support snapshots. Any SQL backup based on snapshots (such as Microsoft Data Protection Manager) will NOT automatically protect the external content.
If you plan to leverage RBS to reduce the size of your databases in SQL, you may have to change your backup strategy based on the above. Major questions are:
- What is your current backup strategy, do you use snapshots or traditional backups?
- How does the RBS provider of your choice work with the existing backup? Will external content be automatically included in backups?
- If yes, make sure you and your SQL DBAs are aware that backup files can be MUCH larger than SQL database size
- If not, how will you handle backup and restore of the external content? For example, if your backup is snapshot-based, you should take same time snapshots of the file system or NAS location with the external content. Make sure you test and thoroughly document all recovery scenarios in this case.
See also Plan for backup and recovery on Microsoft TechNet for other considerations.
Configuring RBS FILESTREAM for SharePoint 2010 and SQL 2008 is not a trivial task. Ghazwan Khairi recently started his SharePoint Quester videoblog, and one of his posts goes step by step through installing and configuring RBS for SharePoint 2010. This includes all script snippets and command line examples that you’ll need. Very helpful and detailed, check it out.
Finally, if you wonder why anyone may want to go into all this trouble with configuring RBS, it is worth reading Chris McNulty’s blog series on top SharePoint performance killers.
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.
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 :-)
BTW, here’re the slides from my “Planning SharePoint 2010 backup and recovery – where do I start?” session
November 19, 2010
We had a good discussion tonight with Buckeye SharePoint User Group in Columbus around how you approach backup and recovery in 2010, and how new features might or might not change your backup strategy. Here’s the slide deck from my session:
Apparently, there’s lots of interest in SharePoint 2010 – few folks already have it running in production, some are playing with it in the labs, while others are learning. Good times, interesting to see how SharePoint landscape changes.
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.
September 30, 2010
Two things happened almost simultaneously this morning: I got an email from someone asking what is the “good practice for backup and recovery with SharePoint 2010″, and I saw the news on release of SharePoint 2010 Disaster Recovery Guide by John Ferringer and Sean McDonough.
You can guess what was my response to that question. There is no one-size-fits-all backup and recovery strategy. There are different techniques and tools available, and the choice always depends on the Restore Time and Restore Point Objectives requested by the business and the costs of implementation. And I also sent the link to the book.
I think the new SharePoint 2010 Disaster Recovery Guide is a great read for SharePoint admins who need guidance on where to start with backup and recovery planning. Judging by the table of contents published by Sean I think the book keeps and highlights all the great insights you could find in the SharePoint 2007 version of this book I read and reviewed last year, and puts the material in the logical order to make it easier to read and understand. Congrats to John and Sean and the book release!