locked
SharePoint DB restore RRS feed

  • Question

  • Hello, 

    Content in your staging and production are lot different due to constant changes in production. I want to restore content DB from production to staging to solve this. We only have one site collection which utilizes out of the box features, CSS , infopath. 

    Is it ok to restore this and should I expect issues if I do this ?. 

    Environment:

    SharePoint 2013, 

    Windows 2012

    SQL server 2012

    Thank you 


    @R


    • Edited by youlearn Thursday, October 11, 2018 9:51 PM Everyone , My intention is to restore from production to staging and I wrote the opposite earlier. My Apologies
    Thursday, October 11, 2018 2:24 PM

Answers

All replies

  • Technically it's possible but not advisable. There will be a data loss.  
    Thursday, October 11, 2018 3:32 PM
  • Hi youlearn.

    You can do that, but it is recommended to restore the content database to a separate web application to avoid any kind of interference or data loss.
    Anyway, it would be better using a different strategy (i.e., using a migration tool) if possible.

    Bye.


    Luigi Bruno
    MCP, MCTS, MOS, MTA

    Thursday, October 11, 2018 3:56 PM
  • this is not safe operation. More often people restore production db on staging to keep environments in sync but not vice versa. So I would recommend to consider this option only if absolutely necessary. If there is another way (e.g. migrating content using some migration tool) I would recommend to use it instead.

    Blog - http://sadomovalex.blogspot.com
    Dynamic CAML queries via C# - https://github.com/sadomovalex/camlex

    Thursday, October 11, 2018 4:05 PM
  • Hello, 

    I want to restore from production to staging and wrote the opposite in my original post . I apologize for the confusion. 


    @R

    Thursday, October 11, 2018 9:52 PM
  • then you're fine. Use this resource on how to do this:

    https://docs.microsoft.com/en-us/sharepoint/administration/move-content-databases


    Thursday, October 11, 2018 9:56 PM
  • Hi,

    You can also refer to below thread:

    https://sharepoint.stackexchange.com/questions/198814/restore-production-content-db-to-test 

    Best regards,

    Allen Bai


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Friday, October 12, 2018 2:46 AM
  • Hello, 

    I want to restore from production to staging and wrote the opposite in my original post . I apologize for the confusion. 


    @R

    Thanks for clarifying the scenario.
    You can either backup and restore the content database using SQL Server or use the Backup-SPSite and Restore-SPSite cmdlets.
    Also take a look at the article at https://docs.microsoft.com/en-us/sharepoint/administration/move-content-databases.

    Bye.


    Luigi Bruno
    MCP, MCTS, MOS, MTA

    Friday, October 12, 2018 7:12 AM
  • Hi,

    If you think the replies are helpful, you could mark them as answers. It will help others who meet the similar issue.

    Best regards,

    Allen Bai


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Monday, October 15, 2018 6:53 AM
  • Hi,

    I am willing to hear from you. 

    Best regards,

    Allen Bai


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Friday, October 19, 2018 9:11 AM
  • Allen, 

    I was cleaning up old posts and realized that I did not reply to this. 

    I took your advice and was able to restore from production to Staging and it worked fine. All the points mentioned about are still valid based on different scenarios. 

    Thank you for your help. 

    @R 


    @R

    Thursday, January 24, 2019 5:14 PM