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

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

Fri, 01 May 2009 11:38:23 GMT

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

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

Just do I(nformation)T(echnology) — Fri, 01 May 2009 12:04:37 GMT

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

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

~ Just do I(nformation)T(echnology) ~ — Fri, 01 May 2009 12:04:51 GMT

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

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

John Ross — Fri, 01 May 2009 22:21:41 GMT

Great news!!

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

-John

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

Stefan_Gossner — Fri, 01 May 2009 23:30:28 GMT

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

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

Eric Fontaine — Mon, 04 May 2009 22:00:24 GMT

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

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

Stefan_Gossner — Tue, 05 May 2009 09:33:09 GMT

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

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

ed — Thu, 07 May 2009 09:24:46 GMT

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

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

Stefan_Gossner — Thu, 07 May 2009 09:36:36 GMT

Hi Ed,

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

Cheers,

Stefan

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

Serge van den Oever — Fri, 12 Jun 2009 10:36:59 GMT

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.

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

jatdesi — Tue, 23 Jun 2009 00:11:56 GMT

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!

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

Stefan_Gossner — Tue, 23 Jun 2009 10:37:00 GMT

Best is to use SQL backup/restore.