Setup D/R SharePoint Site with SQL Tools and Avoid Full Crawl


  • Can a SP Farm be constructed, content databases restored with SQL and reattached to the Farm, and the Index restored from backup(s).  If so what are the procedures and caveats?  Our Farm consists of 8 content databases; 7 are static and ave. 200 GB.  The 8th receives documents through an upload process that runs at night.  When it approaches 200 GB, it will be frozen and a 9th started.  Users only search and view the documents; no adds, changes, or deletes.  There are approximately 12.5 million documents, and performing a full crawl takes quite awhile.  We do, however, have quite a lot of control over activity that alters the Farm.

    Thanks for your thoughts and consideration,

    Paul F.

    Thursday, March 16, 2017 7:31 PM

All replies

  • Is this a warm standby DR scenario, or just simply restoring from backups (e.g. tape) to a brand new farm that you're building immediately after the disaster event?

    If it is the former, I would just suggest standing up a separate Search Service on the DR farm and, with the CDBs replicated and mounted in a read-only state on the DR farm, simply crawl the Web Application(s). This way Search remains fresh without having to concern yourself with a long full crawl time.

    Trevor Seward

    Office Servers and Services MVP

    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Thursday, March 16, 2017 7:35 PM
  • It would be the later.  Both in the "real disaster" and the "d/r test" scenarios, we don't know the machines we will be assigned nor the geographic location.
    Thursday, March 16, 2017 7:48 PM