SharePoint Farm Restore Common Mistake

SharePoint Farm Restore Common Mistake

Most of the SharePoint migratory see this error while moving from Development to TEST or TEST to Production the error is very straight forward and understandable.

Object TP_Content_2500
(previous name: TP_Content) failed in event OnRestore.
For more information, see the spbackup.log or sprestore.log file located in the backup directory.

SqlException: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
RESTORE DATABASE is terminating abnormally.

You can allow any procedure to Restart the database its happen when MS SQL server didn't find any custom configuration information like Path or invalid ID.

How to solve this error

Sharepoint Restore Screen

   There is no doubt that this is Database issue so you need to fix these three thing

1. New Directory Name
2. New Database Name
3. New Database Server Name

New Directory Name

This is the most unprecedented mistake we do because SharePoint provide you by some default information form past system. If you check two black arrow one is pointing Database Physical Drive other Instant name these two should be check first either its correct or not, because in production this path change from database side so you need to confirm path is correct or not.

Database Name

Sometime database exist with same name you have to make sure that this database of same name isn't present on database on in physical path.

Database Server Name

Database server name should be accessible from the application server and of-course name should be correct. 

Above all are the reason for MS SQL as SqlException for Restart the database.