regarding the SharePoint_Config database is missing (SharePoint 2019 On Premise)

SHUO .H 706 Reputation points
2021-01-12T16:35:54.387+00:00

Hi there,

I ran into a problem is my SharePoint_Config is missing. because I deleted it Inadvertently and no backup. As far as know, when the SharePoint_config does not exist in the database, if I perform the SharePoint configuration wizard we could choose, "disconnect from this server farm" then we could rebuild the server farm once again. currently my problem is I choose the "disconnect from this server farm" my WFE always tell me it cannot find SharePoint_Config DB or cannot login.

my environment,

  1. SharePoint 2019 On Premise
  2. TWO WFE plus TWP Batch Application -> 1 WFE and TWP batch Application servers have disconnected. Just only one WFE cannot be done. There is a Central Administration WEB SITE inside. this WFE host the SERVER farm.
  3. SQL AG

Is it possible to handle this trouble??? any ideas??? ...

Thanks

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,227 questions
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,810 questions
0 comments No comments
{count} votes

Accepted answer
  1. SHUO .H 706 Reputation points
    2021-01-14T04:40:34.707+00:00

    Hi both,

    I solve it out by using the following command:

    Disconnect-SPConfigurationDatabase -Confirm:$true


2 additional answers

Sort by: Most helpful
  1. Trevor Seward 11,681 Reputation points
    2021-01-12T18:45:38.22+00:00

    You will need to build new SharePoint servers and create a new farm. You won't be able to disconnect the existing SharePoint servers or uninstall SharePoint Server as they cannot reach the Config db.


  2. ChelseaWu-MSFT 6,316 Reputation points
    2021-01-13T01:46:29.88+00:00

    The current farm is not possible to recover with the Configuration database deleted with no backup.

    As Trevor suggests, you will have to start over and build a new farm instead.


    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. **