Welcome to TechNet Blogs Sign in | Join | Help

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

As I discussed in an earlier article backup/restore between farms for publishing sites was unsupported due to the fact that MOSS often stores absolute URLs to the Page Layout in the properties of a Publishing Page. Workarounds had to be used to adjust the incorrect URL after a restore to ensure that no exceptions occurred.

The good news is: due to the large number of customers requesting this feature Microsoft has decided to modify SharePoint in a way that it is now able to properly handle this situation!

Starting with the April Cumulative Update SharePoint now officially supports backup/restore operations for publishing sites between different farms!

Please ensure to have SP2 installed before installing the April CU as this is the only way to guarantee that all recent changes to SharePoint are available on your farm.

Published Friday, May 01, 2009 9:59 AM by Stefan_Gossner

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

Friday, May 01, 2009 4:38 AM by Stefan Go??ner : Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

# Stefan Go??ner : Common error situation when using backup/restore to transfer a database to a new farm on MOSS 2007

PingBack from http://blogs.technet.com/stefan_gossner/archive/2008/03/12/common-error-situation-with-when-using-backup-restore-to-transfer-a-database-to-a-new-farm-on-moss-2007.aspx

Friday, May 01, 2009 5:04 AM by Just do I(nformation)T(echnology)

# Backup/Restore van Publishing sites over farms is vanaf heden mogelijk

Voorheen was het niet mogelijk Sharepoint sites die de publishing features gebruiken te restoren op een

Friday, May 01, 2009 5:04 AM by ~ Just do I(nformation)T(echnology) ~

# Backup/Restore van Publishing sites over farms is vanaf heden mogelijk

Voorheen was het niet mogelijk Sharepoint sites die de publishing features gebruiken te restoren op een

Friday, May 01, 2009 3:21 PM by John Ross

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

Great news!!

Does that sites that had the issue previously?  Or only prevent the issue from happening moving forward?

-John

Friday, May 01, 2009 4:30 PM by Stefan_Gossner

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

Hi John,

I'm not completely sure. What I can see is that there is a code change in the DB attach code.

So I would suggest to detach and reattach the content DB. Then you should be on the save side.

Cheers,

Stefan

Monday, May 04, 2009 3:00 PM by Eric Fontaine

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

Hi Stefan,

Great news, thank you for the info.

Do you know if the fix change the manner than Sharepoint store the Publishing page URL (use relative URL rather than absolute)?  Or is a implementation of the Workarround in the STSAdm backup/restore command?

Thanks

Éric

Tuesday, May 05, 2009 2:33 AM by Stefan_Gossner

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

Hi Eric,

this works also for SQL level backup/restore with DB attach. So it is not an STSADM only fix. I did not analyze all the changes in detail (there are quite a lot for this fix) so I'm not sure if this is a one time fix during STSADM restore and/or DB attach or if it also affects ongoing operation later.

Cheers,

Stefan

Thursday, May 07, 2009 2:24 AM by ed

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

Please update your bloglinks. Guess you're too busy dealing with all the MOSS updates and sp's ;-) cheers

Thursday, May 07, 2009 2:36 AM by Stefan_Gossner

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

Hi Ed,

thanks for the hint! Added a couple more blogs to the list.

Cheers,

Stefan

Friday, June 12, 2009 3:36 AM by Serge van den Oever

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

Could backup/restore be a good approach for content deployment when you make sure that in your edit farm all "static" content is managed in a separate site collection? Dynamic data should be managed in a different site collection (in a different content database) on the production farm. If you would deploy content this way you can make complex changes to content types and site instances through code and deploy them in a breeze. This scenario would also support rollback by just attaching the previous DB. Really interested in your thoughts on this.

Monday, June 22, 2009 5:11 PM by jatdesi

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

Hi - I have a question:  I am trying to see if I can setup a test environment that mimics our production MOSS+Project Server environment.  As of now, I will have to use a different domain to setup the test environment.  The number of servers in both environments will be same.  Does the April CU need to be applied to the production env first, then to the test,  and finally then can I use the backup/restore (from central admin) to restore to the test env?  Or, it is better to use stsadm?

Any help is appreciated!

Tuesday, June 23, 2009 3:37 AM by Stefan_Gossner

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

Best is to use SQL backup/restore.

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker