Restore error: "SqlException: The operation did not proceed far enough to allow RESTART

Question

1.00/5 (2 votes)

See more:

SharePoint2010

Dears ,
I have the following situation :
I have a development SharePoint 2010 environment on a test server , i want to move for the production environment to a different server , i have tried almost everything regards the Backup and restore, i have tried using the Central Administration , SP powershell commands but with no luck ,
in some cases i had the following error (sample):

Object StateService_0e609739aea044189d82651f721ce4fd 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

in other cases i had the powershell telling me that i am trying to restore from a SharePoint version to a different version , while i am so sure that the two servers are identical to each other .. regards the OS and SP2010 and SQL too..

Please any help ,,
If you have good articles please post links for me ..
Appreciated

Posted 27-May-14 4:52am

rushdi obeidat

Add a Solution

Comments

karthik Udhayakumar 27-May-14 14:43pm

Hi Rushi,
Do you want to migrate the data from test environment to production environment?
The error msg is self explanatory that it describes that the version is different.
Some quetions to guide you further:
How you are so sure did you check the version?
Did you check the version of Sql server Installed in test and production environment?

||Karthy||

rushdi obeidat 28-May-14 1:09am

Dear karthy,
Thank you for your reply.
Yes i want to migrate from test to production, i thought that i really have a version issues but when i checked the SP versions they both the same, when i checked the SQL there was a difference between them but i did the upgrade to the MS-SQL it self and the DB Server OS too and now they are both identical, but with no luck .. :(
still have the same issue.Any ideas ?!?!

karthik Udhayakumar 29-May-14 17:42pm

Sorry bit busy did you complete this action ,If not pls check the event log and let know ,another suggestion is to check your permission for restoring to the server or check for the destination path existency.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)