Sharepoint 2010 test environment - content databases migration question
I have a SharePoint 2010 test environment that I want to populate with data from my production environment. What is the best procedure to do it. I was thinking about doing something similar to database attach upgrade (delete first default database and attach a copy from production using "stsadm -o addcontentdb"). Any other recommendations or suggestions or words of caution? Thanks!
Last Comment
ASKER CERTIFIED SOLUTION
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.
if your production is MOSS ( you use word upgrade ) its better to use stsadm.exe -o preupgradecheck before you start the process .
ASKER
Both production and test is SP 2010.
You dont really need the stsadm command in this case .
ASKER
How do I attach the root database then?
what do you mean by root data base ?
you will move content data base from production to test environment ,it can be any content data base attach to the web app where site collections are running. you will have those site collections and contents available in your demo env . Let me know .
you will move content data base from production to test environment ,it can be any content data base attach to the web app where site collections are running. you will have those site collections and contents available in your demo env . Let me know .
ASKER
I am back home now - I will take a look at that tomorrow morning. Thanks!
ASKER
I must be doing something wrong. I used the stsadm command to attach the database and it is attached but there is no site collection associated with it...
can you make sure that you dont have root site collection already in the web app you are trying to attach to , incase you have root site collection in data base also it will fail .
try to remove it from web app and use browse content from unattached data base option from CA to see if that data bass really brought soem thing with it .
try to remove it from web app and use browse content from unattached data base option from CA to see if that data bass really brought soem thing with it .
ASKER
I used PowerShell and everything worked. Thanks for your help.
Microsoft SharePoint
Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.
40K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
