How to fix “Cannot complete this action” Backup Error by SharePoint Recovery? : SharePoint Database Repair Blogs

Published by Jacob Martin on November 20, 2013

Basically this situation occurs when you try to backup restore or migrate the sites between two server farms. You can get the biggest problem while migration site between two farms is that the user SID gets screwed for good and then the hell breaks loose when you cannot get users log in to the site the permissions are messed up. Backup is the most important method to recover from corruption of SharePoint database. Therefore, you have to select some other SharePoint recovery methods when the back gets damaged by itself. However, you may not restore data by using backup. In fact, restoration process completes successfully but data is not seen when SharePoint site is open. This is the sign for corruption of SharePoint database which force you to take SharePoint database recovery solutions when there is no backup copy of the database.

Causes:

The error “Cannot complete this action” are caused by the corruption of the backup files or by missing system files or broken system registry structures. This all can happen due to virus infection or an incomplete backup process or unexpected system shutdown. This is a critical sign of an unstable system which is typically caused by improper maintenance of the computer system.

Solution to repair the error:

There are some of the solutions which would work for this error. Here are some SharePoint repair steps to follow:

First, open SQL Server Management Studio and select New Query from the menu bar and then run the following command-

• ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE
• DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS)
• ALTER DATABASE SET MULTI_USER

All these will help you to repair the corruption of SharePoint database. After doing all the steps, create a backup of the SharePoint site.

With the above mentioned methods, if you face some of the problems to fix the issue, then you need a SharePoint recovery tool so as to solve the above problem. With this recovery tool, you can easily recover documents and site in critical situations. This software is designed to do a full scan of the database and also recover SharePoint 2007 and 2010 database in all corruption scenarios. This tool also allows the user to retrieve share point database like tables, documents, labels etc. this software is incorporated with simple and rich graphical user interface to offer easy SharePoint recovery.