locked
any reason to take backups of the SharePoint search databases? RRS feed

  • Question

  • Hello -

    I currently have simple mode recovery set up as the backup type for out four search databases (admin, analytics, crawl, link). 

    Any reason not to exclude these from backup?  It's simple enough to just delete search application and recreate new one with new databases and conduct a full crawl if we run into any issues.   The GUID in the db names is not a concern.  

    thanks

    Tuesday, September 24, 2019 6:11 PM

Answers

  • Hi,XRS,

    That depends on if the information in the database is useful to you. For example, if you want to keep the crawl rules, you need to backup the search admin database. 

    Function of these four databases:

    1.The crawl database stores tracking information and historical information about crawled items. For example, it stores information about the last crawl time, the last crawl ID and the type of update during the last crawl.

    2.The link database stores information extracted by the content processing component. In addition, it stores information about search clicks; the number of times people click on a search result from the search result page

    3.The analytics reporting database stores the results of usage analytics. In addition, it stores statistics information from the analyses.

    4.The search administration database stores search configuration data, such as the topology, crawl rules, query rules, and the mappings between crawled and managed properties. It also stores the access control list (ACL) for the crawl component. 

    Best Regards,

    Michael Han


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

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    • Marked as answer by XRS Wednesday, September 25, 2019 11:26 AM
    Wednesday, September 25, 2019 6:32 AM

All replies

  • Yes it is important to keep those db's. You will loose all your custom & managed properties your team built. and also most of the clients there Search Application will be huge and it's not that simple to just give a Full Crawl. So, it's always good to have those databases backed-up so, in case if anything happens you can simply reconfigure by pointing those databases.

    Thanks & Regards,

      

    sharath aluri

    Tuesday, September 24, 2019 7:03 PM
  • Hi,XRS,

    That depends on if the information in the database is useful to you. For example, if you want to keep the crawl rules, you need to backup the search admin database. 

    Function of these four databases:

    1.The crawl database stores tracking information and historical information about crawled items. For example, it stores information about the last crawl time, the last crawl ID and the type of update during the last crawl.

    2.The link database stores information extracted by the content processing component. In addition, it stores information about search clicks; the number of times people click on a search result from the search result page

    3.The analytics reporting database stores the results of usage analytics. In addition, it stores statistics information from the analyses.

    4.The search administration database stores search configuration data, such as the topology, crawl rules, query rules, and the mappings between crawled and managed properties. It also stores the access control list (ACL) for the crawl component. 

    Best Regards,

    Michael Han


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

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    • Marked as answer by XRS Wednesday, September 25, 2019 11:26 AM
    Wednesday, September 25, 2019 6:32 AM