Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Links (3/13/2008) « Steve Pietrek’s SharePoint Stuff

Links (3/13/2008) « Steve Pietrek’s SharePoint Stuff — Fri, 14 Mar 2008 03:36:37 GMT

PingBack from http://stevepietrekweblog.wordpress.com/2008/03/13/links-3132008/

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Emmanuel Desigaud — Sun, 30 Mar 2008 10:10:00 GMT

Hi Stefan,

Why haven't you written this post 6 months ago :) We’re experiencing so many problems that might be linked to this!!

Regards

Emmanuel

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Thomas — Thu, 10 Jul 2008 18:05:32 GMT

To move application between server farms, should we use backup/restore or export/import?

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Thu, 10 Jul 2008 18:08:17 GMT

Hi Thomas,

You need to use export/import.

Cheers,

Stefan

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Charlene — Tue, 05 Aug 2008 08:15:15 GMT

Stefan,

I created a prototype site for a client on my MOSS 2007 server. Didn't use any MOSS features. Backed it up (on my server) and he is restoring it on his WSS server; but now he's getting this error:

An error occurred during the processing of . Could not load file or assembly 'Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. "

Do you think i should have used export/import or should I go into the master page and remove references... or what??

Thanks for all your info!

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Tue, 05 Aug 2008 09:20:43 GMT

Hi Charlene,

this problem is different. The DB content requires MOSS and you are restoring on a WSS server.

That does not work. If the DB content requires MOSS you have to use it on a MOSS server. WSS is not sufficient.

Cheers,

Stefan

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

charlene63 — Wed, 06 Aug 2008 00:58:01 GMT

Stefan,

But i did this in a sandbox environment... only problem there was the server names all needed updating so I went into the database and fixed the server names.

Only thing different is my client and I both upgraded to SP1. Could this be the reason why

Another blogger said i need to "redeploy the package" and it would update the GAC and all would be well... but i have no idea how to do this!!

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Wed, 06 Aug 2008 01:04:34 GMT

Hi Charlene,

doing such a direct manipulation of the DB content means that you cannot expect to get any support from Microsoft for your site.

Never ever do this to a database you would like to keep!

Cheers,

Stefan

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Tonny — Thu, 07 Aug 2008 00:10:21 GMT

Great fix! Thank a lot. We were struggling with this for a while, but we also have another issue. We were getting the error on your post when going to the "Page Settings and Schedule" page. After running your fix it worked on some pages but now we are getting a "User cannot be found" error messages on pages that were created on the source server. I tried creating a script to modify the "Created By" and "Contact" fields, I was able to change the Contact but not the Created By property. Have you encountered this before or do you know how to change this property?

Thanks!

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Thu, 07 Aug 2008 10:05:31 GMT

Hi Tonny,

sounds like a well known problem in MOSS.

A hotfix for this is currently in the works and should be released soon. Please open a support case to ensure that you get the fix as soon as it becomes available.

Cheers,

Stefan

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Tonny — Thu, 07 Aug 2008 17:14:29 GMT

Thanks Stefan. Yes we had already open a support case for this but there was no resolution, we were just told they will consider fixing it on the next version of SharePoint... I'll keep an eye on it.

Thanks again.

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Tonny — Thu, 07 Aug 2008 22:57:04 GMT

Got the answer by posting it on a forum! So I added the code on the post to your script to fix the "orphan users."

You encounter this issue when backup/restoring a site to a different server and then delete the users on the restored site from the older server (in our case it was a stand alone server). When you go to page settings and schedule from a page created on the source server you get an error "User cannot be found"

http://forums.msdn.microsoft.com/en-US/sharepointdevelopment/thread/219a83b7-019a-4379-9f47-2201faa0a7f6

Tonny

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Thu, 07 Aug 2008 23:57:49 GMT

Hi Tonny,

as indicated: there is a hotfix in the works which should address this.

Cheers,

Stefan

SharePoint Backup and Restore : Moving content across environments

Subhajit's Blog — Sat, 09 Aug 2008 10:27:46 GMT

If you thought that moving content from one environment to the other using SharePoint backup and restore

SharePoint dev strategies - it's not all about Features!

Chris O'Brien — Mon, 29 Sep 2008 02:03:21 GMT

Something I've been meaning to discuss for a long time is the decision to develop SharePoint artifacts

SharePoint dev strategies - it's not all about Features!

Mirrored Blogs — Mon, 29 Sep 2008 02:12:15 GMT

Something I've been meaning to discuss for a long time is the decision to develop SharePoint artifacts

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Ralf Günther — Mon, 13 Oct 2008 22:27:34 GMT

Hi Stefan,

many thanks for this very interesting blog - a topic very common in SharePoint projects.

1. Is a backup/restore of SQL databases supported for migrating just SharePoint collaboration site collection (meaning the 'Publishing' feature is not used and therefore disabled)?

2. Does an stsadm 'preparetomove' before the backup/restore opearation help in any way?

Many thanks in advance,

Ralf Günther

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Thu, 16 Oct 2008 10:36:51 GMT

Hi Ralf,

1. there are currently no known issues for non-publishing sites.

2. no. This operation does not change the links in the database.

Cheers,

Stefan

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Adrian — Fri, 24 Oct 2008 05:37:26 GMT

I wonder...

I am having what seems to be a related problem, but with my /masterpage/ gallery...

The site was restored from a backup from another farm. Obviously there are users in here that don't belong (ie, users from the other farm).

The problem is, that basically I cannot open any of the master pages. If i try opening them via the webdav interface, VS or notepad or any other text editor says "file not found". When I try to open one of them with SharePoint Designer, nothing happens! It just displays an hourglass for half a second after I double click the filename.

On some further investigation, I've found this happens for not all, but most of the pages in the masterpage folder.

SOME of the "Modified User"s that I click on tell me that the user doesn't exist. But I can open some of these files with no problem?? Whether or not the user still exists doesn't seem to be what's causing this...

I haven't had any problems with any other library or list on this same restored site, only the _catalogs/masterpage!

Thanks for reading

Adrian

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Fri, 24 Oct 2008 09:26:46 GMT

Hi Adrian,

I haven't seen this flavor.

Please open a support case with Microsoft to get this analyzed.

Cheers,

Stefan

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Darren — Wed, 29 Oct 2008 06:41:58 GMT

...except that export/import rarely, if ever, completes without crashing. Especially for larger site collections. For us, the only option is to backup and restore the SQL database.

Once that is done, I would suggest running the stsadm extension available here:

http://stsadm.blogspot.com/2007/08/fix-publishing-pages-page-layout-url.html

It solved the problem for us quickly and easily!

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Ajay — Mon, 10 Nov 2008 23:42:41 GMT

Hi Stefan,

Using content deployment the Sharepoint desginer workflows don't come through.

Using stsadm -backup and stsadm - restore workflows come through.

What do you suggest for Sharepoint designer workflows

Thanks

Ajay

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Tue, 11 Nov 2008 10:33:14 GMT

Hi Ajay,

I haven't been aware that content deployment and stsadm export/import behave different for SPD workflows. Are you sure about this?

If yes, I would suggest to open a support case to get this analyzed.

Cheers,

Stefan

Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Ajay — Tue, 16 Dec 2008 03:26:46 GMT

Hi Stefan,

Sorry for late follow up...regarding workflows

I mentioned backup-restore... not export-import.

Cheers,

Ajay

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Tue, 16 Dec 2008 12:57:13 GMT

Hi Ajay,

you mentioned content deployment - which uses export - import.

Anyway: please open a support case to get this analyzed in more detail.

Cheers,

Stefan

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Radi A. — Fri, 16 Jan 2009 06:16:37 GMT

Hi Stefan,

Our "Create Hierarchies" variation operation is failing due to page layouts with incorrect URL's. I believe we restored the content with the backup/restore functions and that would be why our links are incorrect. Is this by design of the backup/restore function or a bug?

Thanks,

Radi A.

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Fri, 16 Jan 2009 15:17:36 GMT

Hi Radi,

as you can see in the article above this is by design.

You should not use backup/restore to transfer a publishing site collection to farm with different server names.

Cheers,

Stefan

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Hanif — Mon, 19 Jan 2009 16:16:06 GMT

Hi Stefan,

I was getting "File Not Found" error when i was trying to restore site collection backup from one server farm to another.I downloaded your console application and followed the steps mentioned above.When i ran the console app, i could see that the old server url's were getting replaced by the current server url's.However even after running this application, i'm still getting this "File Not Found" Error.Have i missed something here?

Any help is higly appreciated.Thanks in advance.

Regards,

Hanif

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Mon, 19 Jan 2009 16:22:47 GMT

Hi Hanif,

you should not use backup/restore at all.

The workaround above should work but backup/restore is still not supported for your scenario.

Please use stsadm -o export/import to transfer the database content to a new farm.

Thanks,

Stefan

SharePoint Error : System.ArgumentException. Value does not fall within the expected range

chris_thanks — Tue, 20 Jan 2009 06:39:21 GMT

之前做SharePoint的时候遇到这个错误.....

System.ArgumentException.Valuedoesnotfallwithintheexpectedrang...

Creating a SharePoint variation hierarchy fails: “An error was encountered performing this operation”

Integrating Radi with SharePoint and Dynamics CRM — Tue, 20 Jan 2009 08:36:45 GMT

It doesn’t give you much more details than the following message: "An error was encountered performing

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Subhasha H.L — Tue, 20 Jan 2009 12:56:26 GMT

For "file not found" error check for search service. May be error with search services. have you restored to different server? The native backup nad restore is for restoring to the same machine.

Recomendación de artículos Febrero 2009.

Aprende a Dominar SharePoint con tips de los expertos — Thu, 12 Feb 2009 08:17:43 GMT

SharePoint Diagnostics (SPDiag) Tool v1.0 for SharePoint Products and Technologies The real power of

Recomendación de artículos Febrero 2009.

Luis Du Solier G. - SharePoint en Español — Thu, 12 Feb 2009 08:19:56 GMT

SharePoint Diagnostics (SPDiag) Tool v1.0 for SharePoint Products and Technologies The real power of

Recomendación de artículos Febrero 2009.

SharePoint en Español — Thu, 12 Feb 2009 08:54:56 GMT

SharePoint Diagnostics (SPDiag) Tool v1.0 for SharePoint Products and Technologies The real power of

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

BT — Sat, 04 Apr 2009 04:40:05 GMT

hi Stefan, I could not locate any information on product docs regarding your statement "... Official documentation of this support limitation is currently in the works..." Is backup/restore not fully supported between farms as of now? Thank you for your great article!

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Sat, 04 Apr 2009 17:15:36 GMT

Hi BT,

as outlined in the blog article: currently not supported for site collection using the publishing feature.

Cheers,

Stefan

Recomendación de artículos Febrero 2009.

SharePoint en Español - Luis Du Solier G. — Tue, 07 Apr 2009 10:30:23 GMT

SharePoint Diagnostics (SPDiag) Tool v1.0 for SharePoint Products and Technologies The real power of

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Esteban — Tue, 21 Apr 2009 15:41:01 GMT

Hallo Stefan,

can you please help me with a quick step by step copying the site collection from one fram to another?

I have A new clean MOSS environment, with a site collection (collaboration site).

And I have a very well used old Moss environment, both Moss enterprise edt.

I want to copy all the data from the old site collection to the new one. The size of the old site is approx 50GB... Can I still use the stsadm tool to do a export / import?

What is the fileextension for the file?

Thanks

//Esteban

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Tue, 21 Apr 2009 16:49:15 GMT

Hi Esteban,

on target you need to have an empty site collection - so no template assigned and not a site with collaboration template.

Best is to create the target site collection using STSADM:

STSADM -o createsite -url http://url-to-target-sitecollection -ownerlogin ... -owneremail ...

Then export the site collection using STSADM:

stsadm -o export -url http://url-to-source-sitecollection -filename myexportfile.cmp

Then import the packate into the empty target site collection:

stsadm -o import -url http://url-to-source-sitecollection -filename myexportfile.cmp

Thats it.

Cheers,

Stefan

Red is Green, Up is Down and the Unsupported suddenly becomes Supported!

Stefan Goßner — Fri, 01 May 2009 11:27:23 GMT

As I discussed in an earlier article backup/restore between farms for publishing sites was unsupported

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Anthony Grace — Thu, 07 May 2009 00:33:16 GMT

Hi Stefan,

I'm a little confused. Here's the way I would normally backup/restore to a different farm:

* Create the empty site collection on the destination server

* Using setsitelock, preparetomove and deletecontentdb commands, go on to detach and reattach the content database on the target server by moving the .mdf and.ldf files.

* Use the addcontentdb command

* Reset IIS and perform a full crawl

Am I correct in presuming that this will not cause the error you mention in the blog?

Rgds,

Anthony :-)

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Thu, 07 May 2009 00:45:44 GMT

Hi Anthony,

you would get the same problems. this method will not change the page layout URLs in the publishing pages.

In addition preparetomove should not be used anymore.

See here for details:

http://blogs.msdn.com/toddca/archive/2009/01/30/preparetomove-away-from-running-this-command.aspx

Cheers,

Stefan

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Anthony Grace — Thu, 07 May 2009 02:00:35 GMT

Stefan,

Thanks for getting back - that helps. What I am trying to do in my situation is to move the production site collection to a test VM to try applying the new SP2. What would you suggest as a set of recommended steps for someone attempting this? (I'm sure everyone will want to test the SP2 install first before installing it on production boxes).

Rgds,

Anthony :-)

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Stefan_Gossner — Thu, 07 May 2009 09:47:16 GMT

Just to test the SP2 installation you can use backup/restore.

You just need to be aware that requests to the site might cause exception if you use different host name in the URL than on the source system.

To fix these problems you can use the tool listed above.

re: Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

Arjita Chawla — Wed, 02 Dec 2009 21:48:47 GMT

This is a great post!I had been struggling with this error..I had earlier found another solution one which required an Stsadm command..but since I am not the farm admin..i could not run it..This change using the SPD saved my life .Thanks :)