Databases present only in SQL server not in Sharepoint

Question

Noticed most of the Sharepoint databases are not showing in manage content databases section however I could see those databases are showing in respective SQL server.

can we go head and delete those dbs ( only present in SQL server ). from SQL server ?

Doing so is there any harm?

Answer 1

Hi @sns,

Each web application corresponds to a content database. So, firstly check again and don't overview any web application in your SharePoint farm.

And except content databases, SharePoint creates other databases like configuration database(SharePoint_Config), CA content database(SharePoint_AdminContent_<GUID>) , web application databases. Be careful with them and don't delete them by mistake.

If you are sure that a content database which belongs to a deprecated/deleted web application, you can delete it then. No harm to your environment as per my knowledge.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.