So I am completely new to SharePoint (and SQL) and I have been tasked with creating a brand new intranet for our company where the dev and production areas were set up before I arrived.

I am currently at a stage where I want to migrate my development version to the production server and I am running into troubles. I have tried backing it up and restoring it (in a shared folder in the production sql server) to the new Sp server however it keeps on running into SQL exception errors on various items (wss_content, metadata, etc):

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

I believe this may be due to the fact that the dev server is a single server (sql and Sp on the same machine) while the production is split into two servers SQL, SP and that is causing the errors on restores.

My Question: Am I right or (as I have seen around the internet) that the above exception is thrown because of permission errors on the share folder? If I am right which db's do I need to move and how do I do so?

For the record I am using SP 2013, SQL 2013, all servers are windows server 2012. My SharePoint Site has so far been completely made through SP and SPD.

  • How did you back it up? Did you use Backup-SPSite and then Restore-SPSite? – Bunzab Mar 4 '15 at 9:36
  • I went through CA backup/restore and made a back up of the entire farm. Since I have posted this question I have (or more accurately the admin of the server) has moved the data bases for me however now I get upgrade errors while trying to do a restore through CA even though to the best of my knowledge the versions of SP are exactly the same (servers were set up on the same day). I have a feeling with the db moved across a restore isn't needed is that right? – Roland Mar 4 '15 at 21:40
  • In your situation all you need backed up is your site collection. There is no need to do a farm backup and restore. Have a look at technet.microsoft.com/en-us/library/ff607901.aspx for guidance. – Bunzab Mar 4 '15 at 22:44
  • Thanks for that I thought I was missing something really obvious. However now with sp-restore I am getting this error Restore-SPSite : The content type text/html; charset=utf-8 of the response message does not match the content type.. Apparently it is due to web.config nodes being duplicated however when I checked my web application config files (_wpresources & wpresources web.config files) they don't have any duplicated nodes. – Roland Mar 5 '15 at 0:59
  • Do you have a working site collection in your destination farm? – Bunzab Mar 5 '15 at 9:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.