Avatar of Jack_son_
Jack_son_Flag for Afghanistan

asked on 

Sharepoint 2010 MySite

How can this be moved to a separate application pool and database?  Also, ensuring all the data is moved
Microsoft SharePointMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
ufarooq
Avatar of dbaSQL
dbaSQL
Flag of United States of America image

Avatar of ufarooq
ufarooq

Create a new web application using a new app pool and attach existing my site data base with the new web app. you will have to change the mysite host location in user profile SA.

Other possible way can be to backup and restore this web app to new one, created using a new app pool
And then use that as my site web app. Let us know
Avatar of Jack_son_
Jack_son_
Flag of Afghanistan image

ASKER

Thanks; how can i backup just the mysite and restore?
Avatar of ufarooq
ufarooq

best thign to do here is back up data base attached to mysite using built in SQL tool adn restore with a new name . now attached this restored data base to the new web applicaiton you created for mysite . it will move all your content from old site to the new one .

In order to back up whole web app you can use backup http://technet.microsoft.com/en-us/library/ee748650.aspx
let us know
Avatar of Jack_son_
Jack_son_
Flag of Afghanistan image

ASKER

the issue is mysite is part of the Sharepoint80 IIS site, so it has all the content with it.  Is there a way to extract just the MySite Data?
Avatar of ufarooq
ufarooq

How many site collections you have in this database.
Avatar of Jack_son_
Jack_son_
Flag of Afghanistan image

ASKER

maybe 50 or so
Avatar of ufarooq
ufarooq

It depend , how much non mysite data you have now.  It won't be easy to do 50SC bakup and restore them.  You shpuld create a new  web app to host you mysites. Attcch a cope of the data base from sharepoint80 and remove all the data not rlated to mysite.  
Mysite url will be changed so incase users have bool marks,need to update them.
I'd you have testing env that can make it even more easy.  
Avatar of Jack_son_
Jack_son_
Flag of Afghanistan image

ASKER

Do i just delete all the sites not related when I attach it to a test db?
ASKER CERTIFIED SOLUTION
Avatar of ufarooq
ufarooq

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft SQL Server 2008
Microsoft SQL Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.

50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo