Best practice to move the MDF and LDF from one drive to another (Sharepoint 2016)

Question

Please let me know the best practice to move the MDF and LDF from one drive to another (SharePoint 2016)

Usually we perform the following steps:

1)Pause the crawl
2)Dismount the database from the web app
3) Detach the database from the server
4) move the LDF and MDF
5) Attach the database
6)Mount the database
7)resume the crawl.

While performing /following the above steps, sporadically, some new document are not getting crawled , even after performing multiple incremental crawl.

Am I missing any of the steps here..

Answer 1

You should be looking at pausing the crawl, then the easiest thing to do is just shutdown your SharePoint servers. Otherwise, you can stop IIS via iisreset /stop and the SharePoint Timer Service. Those may get you all you need to detach the database. Note that SharePoint holds onto database connections for a few minutes.

Answer 2

You can follow along here.
https://learn.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases?view=sql-server-ver15

--please don't forget to Accept as answer if the reply is helpful--