SharePoint Content Database Identification post farm decommission
You come to right place, if you have requirement to identify the content database name which you need to restore for recovering some site data. In other words, Suppose, your farm get decommissioned, you only have old Site URL. Your objective is restore this site on Test/Staging farm to recover data. Scope : Content Database SharePoint Configuration Database Table: SiteMap and Objects Select distinct O.Name, S.DatabaseId, S.Path from SiteMap S join Objects O on O.Id=S.DatabaseId where S.Path like '%sites/name%' Note: Microsoft do not recommend running SQL queries even select as well. So, when no option left for you then only use this identify the content database. Thank you