Attach/Detach content database after applying Public Update

MDuBose 716 Reputation points


I'm planning to patch my SharePoint "Test" farm. Before doing so, I want to detach the "Test" content DBs from the "Test" web application and attach the "Prod" content DBs to the "Test" web application. The purpose of this is so I can have an idea of high long the patching process will take on a Production Farm. I have taken a backup of the Prod content DBs and copied them to the "Test" DB server. The "Test" content DBs still exists. My original thought was to attach the Prod DBs to the web application, perform the patch then detach the Prod content DBs and attach the "Test" content DBs backed to the "Test" web application. Will doing so, cause issues with the SharePoint farm?

SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,897 questions
{count} votes

Accepted answer
  1. Echo Du_MSFT 17,141 Reputation points

    Hello @MDuBose ,

    Don't worry, the process can working and will not cause issues with the SharePoint farm.

    For attaching or detaching content DBs in SharePoint Server, you can refer to this article.

    Echo Du


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 additional answer

Sort by: Most helpful
  1. Trevor Seward 11,696 Reputation points

    Yes, that process should work just fine.

    0 comments No comments