none
backup and restore a sitecollection - SharePoint 2010

    Question

  • Hi,

    I have completed my developement successfully, Now have to move it to Production Server.

    I have used custom coding, brading, custom wsps, custom features, custom event handlers. My Site collection has 10+ sites ( team sites). and, there is a list columns dependency among sites (custom coding).

    It is working fine. UAT Completed. :)

    How can I move it from Dev. env. to Prod. Env. Both are in Same Network, luckily.

    Thanks,


    - GEM

    Friday, June 15, 2012 10:24 AM

Answers

  • Follow this solution if you will create a new web application in the producation envirnoment and you are working in the same domain.

    1-Open your UAT database server and backup your content Database (SQL server backup)

    2-in the producation SQL server restore the backup of your content database (SQL server restore)

    3-in the producation server create a new web application , in this page you will find "Database name" for the content database , change the name to the name of your restored database , fill other required fields and click "ok"

    open the new web application you will find everything as in development , make sure delete any test data :D :D

    • Marked as answer by GEMZz Monday, June 18, 2012 9:31 AM
    Sunday, June 17, 2012 2:00 PM
  • Database backup, back-ups all data in de database (offcourse), but depending on your configuration, this could be more then you want to migrate.

    Using Powershell to backup a site(collection) and restore this, you have more control over the exact data that will be transferred.

    Although it is possible to restore this in other domains, you need to consider that security can not be migrated between domains.

    My advise: backup the site(collection) with a bare minimum of security configured. Then restore the site(collection) in a different domain, and correct the security.

    Hope this helps.

    Regards,

    eric


    Willing to learn everything about Sharepoint there is to learn. My blog

    • Marked as answer by GEMZz Monday, June 18, 2012 9:24 AM
    Monday, June 18, 2012 7:03 AM

All replies

  • I think you might need a couple of techniques to move between stages.

    Content can be moved using site(collection) backup and restore.

    Solutions (i assume that custom features and custom eventhandlers are also packaged as wsp) need to be deployed.

    Site(collection) features might need to be turned on/off.

    So it's all depending on how the entire solution is build. there are even third-party tools that aid in this process.

    If buying software, that will do the job for you, is not an option, i think you should take a look at scripting all steps using PowerShell.

    Creating/restoring backups, installing and deploying solutions and turning on/off features can all be done with powershell.

    Remenber that creating a deployment script is also part of development :-)

    You even might want to use a test and/or acceptance server, just to see if functionality and/or deployment will work or fail, before you try it on a production server.

    Regards,

    Eric


    Willing to learn everything about Sharepoint there is to learn. My blog

    • Proposed as answer by Amien123 Sunday, June 17, 2012 9:19 AM
    Friday, June 15, 2012 11:34 AM
  • For a detailed look into the process , please go through this article : http://technet.microsoft.com/en-us/library/cc261687.aspx








    Talib Ali Khan
    SharePoint Specialist
    MCTS
    Blog : http://www.onlineasp.net
    Twitter : https://twitter.com/TalibAliKhan
    LinkedIn: http://sa.linkedin.com/in/talibalikhan

    Saturday, June 16, 2012 8:51 AM
  • Valuable inputs.. :)

    If I want to take a site collection backup and restore from onse server to other server, which contains 3 team sites only with OOB webparts, do I need to take database backup also??

    And, Is it possible to rstore the same backup in other domain?

    What steps/precautions do I need to take?

    Thanks,


    - GEM

    Sunday, June 17, 2012 9:53 AM
  • Follow this solution if you will create a new web application in the producation envirnoment and you are working in the same domain.

    1-Open your UAT database server and backup your content Database (SQL server backup)

    2-in the producation SQL server restore the backup of your content database (SQL server restore)

    3-in the producation server create a new web application , in this page you will find "Database name" for the content database , change the name to the name of your restored database , fill other required fields and click "ok"

    open the new web application you will find everything as in development , make sure delete any test data :D :D

    • Marked as answer by GEMZz Monday, June 18, 2012 9:31 AM
    Sunday, June 17, 2012 2:00 PM
  • Database backup, back-ups all data in de database (offcourse), but depending on your configuration, this could be more then you want to migrate.

    Using Powershell to backup a site(collection) and restore this, you have more control over the exact data that will be transferred.

    Although it is possible to restore this in other domains, you need to consider that security can not be migrated between domains.

    My advise: backup the site(collection) with a bare minimum of security configured. Then restore the site(collection) in a different domain, and correct the security.

    Hope this helps.

    Regards,

    eric


    Willing to learn everything about Sharepoint there is to learn. My blog

    • Marked as answer by GEMZz Monday, June 18, 2012 9:24 AM
    Monday, June 18, 2012 7:03 AM