I have a backup of a sharepoint 2010 farm that I am attempting to restore using Central Admin.
One of the reasons for failure is a content database restore that fails, the error is:
Object WSS_PO_Content failed in event OnRestore. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
SqlException: The restart-checkpoint file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\RestoreCheckpointDB11.CKP' is from a previous interrupted RESTORE operation and is inconsistent with the current RESTORE command. The restart command must use the same syntax as the interrupted command, with the addition of the RESTART clause. Alternatively, reissue the current statement without the RESTART clause.
RESTORE DATABASE is terminating abnormally
I reconstructed the restore command from the restore log and it still produces the same error. The content database is overly large due to it not being set up or managed correctly (it's 230GB).
The location of the farm backup is on a network share.
Other errors I encountered:
Object WSS_Content_8888 failed in event OnPostRestore. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
SPUpgradeException: This content database has a schema version which is not supported in this farm.
Object WebAnalyticsServiceApplication_StagingDB_6f2cd37f-cefa-4c9e-a220-1ca5631fb9e2 failed in event OnRestore. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
SqlException: Exclusive access could not be obtained because the database is in use.
RESTORE DATABASE is terminating abnormally.
UPDATE
I updated the patch status to match that of the source sharepoint installation.
I appreciate any help.
thanks.