Sharepoint 2010 test environment - content databases migration question

MisUszatek
MisUszatek used Ask the Experts™
on
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!

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
I agree with you .Best way to do this is get a backup of data base from production using SQL application . Restore this backed up data base in your demo environment. And then use this command as you mentioned above
Assuming both environment are 2010 you can also back up site collections from production and restore it in demo environment.

Things you need to consider are if you have installed any custom template .
Any features installed in production
Any 3rd party web parts
Custom master page /theme

If any of these are installed on production you will have to install on demo first otherwise that specific web part/ feature will not work.
Let us know if you need more help.

Commented:
if your production is MOSS ( you use word upgrade ) its better to use stsadm.exe -o preupgradecheck before you start the process .

Author

Commented:
Both production and test is SP 2010.
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Commented:
You dont really need the stsadm command in this case .

Author

Commented:
How do I attach the root database then?

Commented:
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 .

Author

Commented:
I am back home now - I will take a look at that tomorrow morning.  Thanks!

Author

Commented:
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...

Commented:
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 .

Author

Commented:
I used PowerShell and everything worked. Thanks for your help.

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