.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

One for the Experts! Is it supported to use stsadm -o mergecontentdbs with mysite/ssp admin content

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :SharePoint



I've inherited rather a mess, the situation is as follows:

1 web application named home.company.com

containing 2 databases:

db_1 - contains:

  • Intranet site collection - http://home.company.com/
  • Used for mysites - http://home.company.com/personal/*
db_2 - contains
  • equal number of mysites to db_1 (about 2500 in each)
  • /MySite - my site host site collection?
  • /SSP/Admin - SSP admin website site collection?

I propose to do the following:

Rename home.company.com web app to ssp.company.com, including hostheader/DNS etc

create fresh home.company.com web app

Move pre-existing home.company.com/ site collection to new web app/database with stsadm -o mergecontentdbs specifiying the one site collection in a file.

merge the remaining 2 contentdbs ENTIRELY in the ssp.company.com web application

The bit I'm not sure about is the last sentence - is it supported to merge these contentdbs as they contain mysites and ssp admin site.

THe ssp admin database itself used for storing the ssp configuration info is obviously a seperate DB.

Why do I want to sort all this out?? Because I need to upgrade the profiles/My Sites to 2010, and to do this I need to attach the relevant databases! As well as th

View Complete Post

More Related Resource Links

Spliting Content DB - mergecontentdbs Vs Admin tool kit


Hi All,

Which of the above two spliting content db process is safe and easy to achieve?

What are the draw back of using either?


Backup through Central Admin fails; works using stsadm

Hi, I'm trying to schedule automatic backups of my SharePoint 2007 site.  I wrote a .vbs script that does the backup with the following line:   objShell.Run "cmd /c stsadm.exe -o backup -directory """ & BACKUP_DIR & SITE_DIR & """ -backupmethod full -item ""Farm\Windows SharePoint Services Web Application\SharePoint - SharePointSites"" > """ & CURR_DIR & "log.txt""", 0, True   I ran the vbs script from the command line and everything worked fine.  I used the Windows Task schedule to run the script as a scheduled task.  The script ran fine and the backup completed successfully (according to the logs), but now if I go to the Central Admin page and try to do a restore, I get the error:   The backup/restore job failed. In order to rerun the backup/restore the timer job must be deleted from the Timer Job Definitions page. Failure Message: Backup or restore is already running.   The odd thing is I can do another backup or restore using stsadm at the command line and it works fine.  I can also run the scheduled task to do another backup and that works fine too.  I just can't do any backups or restores from Cetnral Admin anymore.   Any suugestions or ideas? Thanks. -Cynthia

Move MySite with stsadm backup from FARM A to FARM B within same Domain

Hi, I'd to move, with a series of "stsadm -o backup -url..." command, a lot of mySites from one Farm to another in the same Active Directory. Are there special Tasks after the "stsadm -o restore -newurl ..." command ? Can I handle MySite like a "normal" Team Sites ? I'm not sure what happen, for the Users after the new MySite URL become active (I hope it will not create a new empty one) ThanksTester

MySite user profile site creation of My Content page is created as provisioned failed (unprovisioned

I've been trying to troubleshoot our User Profile Sync and have noticed the profile pages weren't getting updated with everything.  Most content was but things like memberships and the content tabs weren't.  I also saw this error in ULS: ProfSynch: Exception attempting to enumerate site 25a72070-4249-4698-ae99-c2a45d25b08e for ContentDB 23a6e3ef-6d56-4bde-825e-95c6924e2f91: Microsoft.Office.Server.UserProfiles.ProfileSynchronizationInternalException: ProfSynch: The site with ID 25a72070-4249-4698-ae99-c2a45d25b08e cannot be synchronized due to an unprovisioned root web.      at Microsoft.Office.Server.UserProfiles.SiteSynchronizerCollection.GetSynchInfoForSite(SqlDataReader dr, SynchInfo info)      at Microsoft.Office.Server.UserProfiles.SiteSynchronizerCollection.<get_Elements>d__0.MoveNext() I checked in the MySite database under the webs table and noticed all the My Content sites for all of our users had the flag column with the number 1315 in them - (meaning unprovisioned as the error above states).  Cross checking with the User Sync Profile database under the SiteSynch table I noticed all of the sites have NULL for the value under both the LastSynch and ChangeToken columns (The User Profile Service Application - User Profile to SharePoint Full Synchronization  timer job takes care of populating that).&

Central Administration not Available, STSADM password reset errors "job-admin-apppool-change" alread


Hi Everyone,

I think I've shot myself in the foot by not properly following set up instructions.

I have a two-fold problem.  Firstly, my Sharepoint Central Administration V4 site is showing Service Not Available.  This seems to be related to the credentials the Central Administration V4 Application Pool - hitting Test Settings within IIS Manager for the site shows an Authentication and Authorization error for the credentials due to a bad password.

My reading indicates that I should run something to the effect of:

%STSADM -o updatefarmcredentials -userlogin DOMAIN\username -password <new password as set via AD>

This runs into the following Error message

Error deploying administration application pool credentials. Another deployment may be active. An object of the type Microsoft.SharePoint.Administration.SPAdminAppPoolCredentialDeploymentJobDefinition named "job-admin-apppool-change" already exists under the parent Microsoft.SharePoint.Administration.SPTimerService named "SPTimerV4".  Rename your object or delete the existing object.


I've tr

External Content Type - Read List Operation - "Cannot find a collection element of a supported type.


I'm trying to define External Content Type Operations for an External Content Type. I can add a Connection, Type "WCF Service" no problem. And I can define a "New Read Item Operation" using that connection.

But I can't define a "Read List Operation". I get the following error message, in the Return Parameter Configuration: "Cannot find a collection element of a supported type..." it goes on to say - see the help documentation for supported types. I can't find any help documentation on this.

I've tried returning different types in the provider web service but keep getting the same error. What are the supported types the web service can return?

The reading I've done suggests that you can connect to a non-MS web service using a connection type of "WCF Service". Is this correct? If it is what's the best soap format the web service provider should use - Doc/Literal?



Changed DNS, IIS mappings and AAM for mysite - "My News feed,profile,content" okay but MySite link s



Sharepoint 2010 enterprise, I created a DNS entry and AAM for MySite - qnetmysite.company.local and all worked okay, then the customer wanted to change the URL used to access my site to "myqnet" so we deleted the DNS entry and recreated a new one. I changed the bindings in IIS and AAM to point to "myqnet.company.local". I can enter http://myqnet.company.local" and navigate to My News feed, My Profile, My content but when I try to navigate to MYSite the URL it takes me to is the old URL qnetmysite.company.local and internet explorer of course can't find the site. I have done an IIS reset, flushed the DNS on the local PC, when I mouse over the MySite link I can see the wrong URL.

Please can somebody help me?


Site Admin Can't Delete Content In Document Library



I am the admin of a site and need to delete a version of a document someone else uploaded into a document library. In other libraries, when I hover over the document, I get the drop-down which contains the "Edit Item, Open In... and Delete". In the particular library, I don't get that menu. Any ideas why?


MySite crawling warning 'Content for this url is excluded by the server because a no-index attribut


Hi Team,

We have SharePoint farm consisting of 2 WFEs, 1 Application Server and SQL Cluster having 2 nodes.  We are are seeing many of the below warnings in the MySite crawling, more importantly we do not see many of document/s and personal blog not being picked up by the crawler and nothing is searchable. We do not have any Crawl rule on mysite url nor scope rule that points to personal site URL

Can some one help me with finding the reason/cause and solution if any one has come out of this situation.

Advance thank you.


Ramakrishna Pulipati SharePoint Consultant Bangalore, INDIA

WSS3] Deployment error with central admin or stsadm : The method or operation is not implemented

I created under WSS3 / VS2010 a WSPBuilder solution that activat a feature.
All is ok when i deploy via the "Deploy" of WSPBuilder under VS2010.
But when I do the deployment with central admin or stsadm i have an error : "The method or operation is not implemented."

Do you have any idea please ?

SharePoint Tutorial - Content Types

SharePoint content types provide users with a way to manage and organize content in a more meaningful way. It's a reusable of settings you want to apply to a particular type of document in a library or item in a list.

Enabling Users to Maintain SharePoint Content

When SharePoint is installed as a corporate intranet, there is a considerable amount of effort involved in maintaining the content to keep the site relevant. As we discussed in the first few parts of this series, SharePoint has many built-in features to reduce the burden on the site administrator.

Some areas of the site usually contain less-dynamic information. Internal memos and corporate policies are common examples of this information. One option for this information is to post these documents in a document library. Documents in a library are often stored in a few different formats: Word, Acrobat (PDF), or HTML. Each of these formats has its drawbacks.

Application Vs. Content Pages in SharePoint

SharePoint has two types of ASPX pages. One type is the application page, also known as a _layout page. The other type of ASPX page is a content page, also known as a site page. Each of these page types is stored in a different location in SharePoint. When developers create custom ASPX pages, they must decide on the page type.

Enabling Users to Maintain SharePoint Content

When SharePoint is installed as a corporate intranet, there is a considerable amount of effort involved in maintaining the content to keep the site relevant. As we discussed in the first few parts of this series, SharePoint has many built-in features to reduce the burden on the site administrator.

Content Types in MOSS 2007

In this article I will try to describe the one of the best feature in Microsoft office Share Point 2007 called Content Types.

Content types are simply collection of contents.Each content in a Content type can have different settings.Basically it is a reusable collection of settings which you want to apply to a particular category of contents.

Content Query Web Part missing in SharePoint 2010

If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

Unique content within master page based on conditions met


 Hi all-

I would like to present users with unique content based on certain conditions being met as they land on the home page (default.aspx).  The condition logic will be in the VB code behind Page Load event. The content will go in a content placeholder as specificed from the master page. 

However, the content change wouldn't be something small (ie making a panel or label visible or not) but rather it will be different HTML,  Divs and databound gridview content.  The HTML content will be stored in the database.

Can someone point me in the right direction for best practices on how to accomplish this?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend