Monday, September 19, 2011

Site Collection Deleted - Get Database Name

Scenario: Site collection admin deletes root web from a site collection, thereby deleting the entire site collection. Now they want it restored. If you have clearly documented mapping between site collection and content db (assuming you have large number of content db's) you can easily restore the content db and get the site collection restored.

Solution: For all those who do not have it documented. SharePoint config db has a table called "SiteMap" which store site collection to database mapping.

1. Do a SQL backup/restore of SharePoint config database from a time before the deletion occurred. (Remember this is just a SQL restore not SharePoint)

2. Check the dbo.SiteMap table for database information.

No comments:

Post a Comment