Move SharePoint Sites from Central Admi

Howard Bash
Howard Bash used Ask the Experts™
on
Early in my adding sites to SharePoint,  I did not add them to the Web Server/IIS boxes and so I have about a half dozen sites which are hosted in the same IIS as the Central Admin.  How can I move them to another IIS box.  And also,  I realize I will probably need to send off messages to all the users in these sites with the new URL.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
You need to import/export using STSADM.

1.- Make sure both/all intended export/import location are running the exact same version of sharepoint... if same server no problem.

2.- Export (http://technet.microsoft.com/en-us/library/cc262759.aspx)

3.- Import (http://technet.microsoft.com/en-us/library/cc261866.aspx)

4.- Redirect users to new sites... u can use this web part: http://blog.ray1.net/2009/04/redirect-groups-to-specific-site-or-url.html
4.1.- Inform users of new location

5.- Delete old sites
Howard BashSenior Software Engineer

Author

Commented:
Will this representation of the URLs work for the export command?

1) The source URL is http://myShareBuilderServerWithCentralAdmin:1234/OneOfMySite1/  with gets used on import to destination URL

2) The destination URL is http://myShareBuilderServerWithIISAndNoCentralAdmin:2468/OneOfMySite1/

Thanks.


Commented:
Yes, it's all good to try if in doubt.

The export command creates a cab package, you can copy/paste/delete...
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

Howard BashSenior Software Engineer

Author

Commented:
Well the export seems to have worked and "most of the import command appeared to work"  but there was an error (I have the logs) and the site shows in my list of sites but I cannot browse it.

------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
Here is the batch file I used for export  followed by the command line:
------------------------------------------------------------------------------------------------
@ECHO OFF
Echo Running stsadm param1 is URL param2 is outputfile
"C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\stsadm" -o export -url %1 -filename %2 -overwrite -includeusersecurity -haltonwarning -haltonfatalerror
echo Done
pause
------------------------------------------------------------------------------------------------
RunSharePointExport.bat http://nyapmss402v:12637/DesktopEngineering/  c:\sharepointexports\desktopengineering_export1
------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
Here is the batch file I used for import followed by the command line:
------------------------------------------------------------------------------------------------
@ECHO OFF
Echo Running stsadm param1 is Import URL param2 is inputfile

"C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\stsadm" -o import -url %1 -filename %2 -includeusersecurity -haltonwarning -haltonfatalerror

echo Done
pause
------------------------------------------------------------------------------------------------
RunSharePointImport.bat http://nyapmss402v:3768/DesktopEngineering desktopenginerering_export1.cmp
------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
And I will include the import log file section showing the errors.
------------------------------------------------------------------------------------------------
...
...
...
[10/22/2009 10:55:55 AM]: Progress: Importing Group Americas Equity Sales Administration Visitors.
[10/22/2009 10:55:55 AM]: Progress: Starting content import.
[10/22/2009 10:55:55 AM]: Progress: De-Serializing Objects to Database.
[10/22/2009 10:55:58 AM]: Warning: User or group 16 cannot be resolved.
[10/22/2009 10:55:58 AM]: FatalError: User or group 16 cannot be resolved.
   at Microsoft.SharePoint.Deployment.DeploymentLogger.Log(DeploymentLogSeverity severity, SPDeploymentObject deplObject, String message, Boolean throwException)
   at Microsoft.SharePoint.Deployment.DeploymentLogger.Log(DeploymentLogSeverity severity, String message)
   at Microsoft.SharePoint.Deployment.ImportObjectManager.ConvertToDestUserId(Int32 userid, Boolean bAllowFallback, Boolean& bIsGroup)
   at Microsoft.SharePoint.Deployment.WebSerializer.DealWithGroupsOnImport(ImportObjectManager objectManager, DictionaryEntry property)
   at Microsoft.SharePoint.Deployment.WebSerializer.SetObjectData(Object obj, SerializationInfo info, StreamingContext context, ISurrogateSelector selector)
   at Microsoft.SharePoint.Deployment.XmlFormatter.ParseObject(Type objectType, Boolean isChildObject)
   at Microsoft.SharePoint.Deployment.XmlFormatter.DeserializeObject(Type objectType, Boolean isChildObject, DeploymentObject envelope)
   at Microsoft.SharePoint.Deployment.XmlFormatter.Deserialize(Stream serializationStream)
   at Microsoft.SharePoint.Deployment.ObjectSerializer.Deserialize(Stream serializationStream)
   at Microsoft.SharePoint.Deployment.ImportObjectManager.ProcessObject(XmlReader xmlReader)
   at Microsoft.SharePoint.Deployment.SPImport.DeserializeObjects()
   at Microsoft.SharePoint.Deployment.SPImport.Run()
[10/22/2009 10:55:58 AM]: Progress: Import Completed.
[10/22/2009 10:55:58 AM]: Finish Time: 10/22/2009 10:55:58 AM.
[10/22/2009 10:55:58 AM]: Completed with 1 warnings.
[10/22/2009 10:55:58 AM]: Completed with 1 errors.

------------------------------------------------------------------------------------------------

Commented:
Are you site collection admin? Cause the log states that it had problems importing the security settings. As Site Collection Admin you should be able to change the settings. Or you can, if you still got the old site, go over each user that has acces and hover over their names. In the bottom right of IE you will see the link, and the one with dispuser.aspx?id=16 is the one you should remove from that list.
Howard BashSenior Software Engineer

Author

Commented:
I have not found that ID=16 entry.  I click the tab for this site. I click people and groups and none of them show ID=16 when I hover over the list.

Also,  if I did find the culprit,  after the delete,  will the site then launch?
Howard BashSenior Software Engineer

Author

Commented:
Do I need to export again and then import again?  If so, how do I delete the site from the destination?
Although it won't launch it is in the list of sites on the server.

Commented:
hbash... no biggy, the group is not in the site collection, so you have 3 options...

1.- U can import again switching -haltonwarning -haltonfatalerror off.
It should import fine except without the failed items

2.- Create Groups in the import Site Collection to match exactly the groups from the exported Site Collection... don't forget groups are on the Site Collection level not Site level. Then import again.

3.- Import with -includeusersecurity off, then recreate the security.

I would opt for option 3, unless it was going to be a real hassle, and there was a lot of item level perms.
Howard BashSenior Software Engineer

Author

Commented:
How do I clean up the mess that the import caused?   I would imagine I need to clean it up before the import.  Will the import act more like an update for the parts it already created and an insert for those that were not built due to the previous failed attempt?

Commented:
Sorry, yes... delete the site.
Howard BashSenior Software Engineer

Author

Commented:
The Log file looks ok.  But the site does not show up as a tab and clicking it as a link on the all sites page brings up error File not found and suggests going to a web parts maintenance page.

The import had 0 errors. It feels like the web part of the site itself either is not there or somehow not connected to the sites on my sites content iis web servers.
Howard BashSenior Software Engineer

Author

Commented:
Hmm,  it just occurred to me.  Am I being a bonehead here?  The physcial server port I am giving for the import is the content port but the server name is that for the sharepoint admin box.  Perhaps instead of the box i am using, i should specify one of the  IIS web content server names?  Not sure if that matters since the port implicitly referrs to the content server by it's unque port number???

Commented:
Use the url that Central Admin has for the Web Application.
Howard BashSenior Software Engineer

Author

Commented:
I tried with one of the two web servers (which are listed in the central admin and running)  and stsadmin said the url could not be found.  i think that there might be an issue with the content databases.  i have three and i think i probably only need two and something I have mistakenly set is not correct.

1 for Central Admin
1 for Sites Content

But i have three:
SITE_CONTENT (?)
SITE_CONTENT_somebigrandomnumber meaning for central admin (and it seems to be ok)
SITE_CONTENT_COMPANY_NAME

I think before I get these imports correct, I need to make sure that my databases are set correctly.  I believe that some of the database content used for the web pages is in the SQL Database, so this could explain why the content does not seem to be findable.  As though I am exporting from one but importing to the wrong db.


Commented:
Since all your content and the important stuff is in CA, you can delete the other web applications and start again.

Backup for safe measure.
Howard BashSenior Software Engineer

Author

Commented:
How can I determine the linkage of these components?  What I mean is how can I see which db is associated with a site.  If I can determine which db to use for which instance of IIS wouldn't that solve this too?

Also, when you say delete them how and in what order to do so?
stop both web content servers (or also the Central Admin?)
delete the sp sites associated with IIS on a box
delete those same sites on that IIS on that same box
repeat for other web server
restart the web servers
launch the Central Admin and the tabs should launch the sites using a different port number (and server Name?)



Commented:
NO!, delete the applications from Central Admin ONLY.

Forget about SQL and IIS and do everything from CA.
The order doesn't matter, as you're only deleting a useless application.

Your objective:
1.- Export sites from the CA web application to another web application.

Your issue:
1.- The export didn't work because some groups weren't in the new web application, and you have a new web app that isn't functioning properly

Your fix:
1.- Delete the new web app
2.- Start a new export as detailed above (ID:25639783).
Howard BashSenior Software Engineer

Author

Commented:
I am new to building sharepoint farms.  My perception of what you have as a sharepoint farm is as follows.  Using SharePoint, you make web applications and associate them with a content database and build sites within their collections whose content is saved in the web application's content database.  Please correct me on this if I am missing the naming/layout of sites to collections to web apps to sql databases.  

I hear you though,  I will kill the site and import the exported file with the params you suggested and see how that goes.  I'll let  you know.  Thanks.


Commented:
Web App (IIS/SQL) > Site Collection > Sites

Let CA (SharePoint) manage the IIS/SQL
Howard BashSenior Software Engineer

Author

Commented:
I need to understand the assorted pieces I have put in place first though.  I have some amount of users/sites live on this "test" installation and would like to consolidate and shuffle some of my sites with as little impact to users other than perhaps a changed URL.  There are several databases that I have running (content and admin) and am not sure how to determine the usages and move/update web apps and sites into a more reasonable configuration.

For example during my initial setup of the farms when asked for the name of the sql server or to use the default.  In some cases I have chosen a new DB name instead of an exisiting one as I was not sure if using the existing DB might have dropped and created the DB losing other servers content.  Such choices where incorrect need correcting.



Howard BashSenior Software Engineer

Author

Commented:
Also,  I am not clear on how to partition assorted groups and subgroups of people.  How do I divide them among Web Applications, Sites, Sub Sites,etc. ?  I don't mean how do I technologically execute creating sites and putting groups/subgroups into them,  but more what architecturally makes sense?  Do I put groups into distinct Web Apps and sub divide them by Sites/Sub Sites?  Really, a cookbook of a sort to put this together instead of experimenting or having to read through several 500 page documents plus experiments to put it all together,  would be grand.

Commented:
hbash > this question has blown up to basically describe/explain sharepoint. Export/Import answered your original question.

It would take me a long time to write all about Web Applications, Sites, Sub Sites, Groups, etc... and at the end you will get a better description/explanation from technet or by reading a sharepoint book.

Here read these: http://technet.microsoft.com/en-us/library/cc261834.aspx http://go.microsoft.com/fwlink/?LinkID=91741

They're not 500 pages, usually around 80, and just check the index for what u want.


ExpertS exChange is good for asking questions with a quick simple answer.

Howard BashSenior Software Engineer

Author

Commented:
I think you're right and you have been a great deal of help.
Howard BashSenior Software Engineer

Author

Commented:
All good advice. Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial