subject: SharePoint Recovery to Fix "Cannot complete this action" Backup Error [print this page] SharePoint Recovery to Fix "Cannot complete this action" Backup Error
Are you getting "Cannot complete this action" while restoring SharePoint database from backup? Are you unable to restore SharePoint database using stsadm.exe tool? Well, this behavior of Microsoft SharePoint Server may occur due to corruption to the backup. Backup is the most useful method to recover SharePoint database in case of corruption. However, if backup itself is damaged, you are required to opt for other SharePoint recovery methods.
As a practical example of this issue, you may not restore data from a backup that was created using Microsoft SQL Server Management Studio Express. Although, restoration process completes successfully, but you cannot see your data when you open the SharePoint Site. This issue indicates SharePoint database corruption and put you in need of SharePoint database recovery solutions, if another backup copy of the database is not in place.
Cause
As stated above, this problem may occur due to corruption to the backup file. Corruption might occur due to a wide range of reasons, such as virus infection, unexpected system shutdown, incomplete backup process, or backup media errors.
Solution
You can try out the below SharePoint repair steps to work around this problem-
Open SQL Server Management Studio.
Choose New Query from menu bar.
Run the following command- ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE SET MULTI_USER
It would help you to repair SharePoint database corruption.
Once you are done with the above steps, create a fresh backup of SharePoint site.
If the above methods can not help you fix this problem, you run across a critical problem. As a SharePoint Server administrator, you need to come up with a SharePoint recovery solution as quickly as possible.
In such critical situations, you can easily recover SharePoint documents and site using advanced SharePoint recovery tools. SharePoint repair software are particularly designed to perform thorough scan of whole database and recover SharePoint 2007 and 2010 databases in all corruption scenarios.
SharePoint database recovery software are incorporated with extremely simple and rich graphical user interface to offer easy SharePoint recovery. They preserve absolute integrity of your mission-critical data with read-only and non-destructive SharePoint repair conduct.
