Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Separating content of MySite to another database

  Asked By: Adrianna    Date: Jul 12    Category: Sharepoint    Views: 2625

We have a semi-production Sharepoint site that was created with the
MySites content stored in the same database as one of the content
sites (yeah! I know, Big mistake). We are planning on moving to
another farm. On the new farm we have a separate MySites content
database and separate content db's for the various web apps. I would
like to know if there is a way in the process of restoring the data
from the old farm to the new farm to send the MySite content to it's
mysite database (splitting content from existing db to two db's).

If not, should I have to import individual MySite sites to the new
MySite db in the new farm ?



4 Answers Found

Answer #1    Answered By: Irving Hurley     Answered On: Jul 12

Administration to change the content  database where your MySites are
stored. However, since each MySite is itself a Site Collection, you may
want to consider moving everything else to a different content database
and leaving the MySites in the original content database.

Answer #2    Answered By: Tiana Whitaker     Answered On: Jul 12

I was able to export/import (stsadm -o
export) a top level site  from my old farm to the new one with all the
content showing up just fine. I am now having trouble doing the same
with each of the sites in Mysites. I tried the export/import with the
-includeusersecurity option, and that did not work either. The export
reports that is was successful and so does the import. Am I
overlooking something.

Answer #3    Answered By: Alice Chandler     Answered On: Jul 12

My Sites are MOSS so I haven't played with them. Anyone else tried
moving a My Site using Content Deployment?

Answer #4    Answered By: Lynette Sawyer     Answered On: Jul 12

I've played with MOSS a little. If I was
trying to do this here's the steps I'd take.

1) Back up the existing My site  site collection with STSADM -o backup.
2) Go to your desitnation environment and make sure the user has created  their
My Site.
2a) Back that up too, just in case.
3) Restore the My Site from step one to the location in step 2 with STSADM -o

I have no idea if that will work, but that's what I'd try first.

Didn't find what you were looking for? Find more on Separating content of MySite to another database Or get search suggestion and latest updates.