Exploring attached and unattached content databases

A computer system for enabling a user to search for content contained within a content database, the system comprising:

• at least one processor;
• memory coupled to the at least one processor, the memory comprising computer-program instructions executable by the at least one processor for:
• receiving a request to search for a site collection in the content database;
• receiving a request to search for a site in the content database;
• and
• invoking one or more stored procedures, wherein the one or more stored procedures comprise one or more from a group of stored procedures consisting of:
• proc_GetSiteCollectionBestMatch, proc_GetSiteCollectionSubset, proc_GetWebSubset, proc_GetWebBestMatch, proc_GetListSubset, and proc_GetListBestMatch.

One or more computer storage devices having computer readable instructions stored thereon, the computer-readable instructions, when executed by one or more processors, cause the one or more processors to perform acts for searching for data, the acts comprising:

• establishing a connection from a content management application to an unattached content database;
• receiving an indication to perform a search for a site collection;
• receiving a site collection selector user interface (UI) to perform a search for a site collection;
• entering one or more search requirements for searching for a site collection;
• receiving from the content management application a list of one or more site collections matching the one or more search requirements for the site collection;
• selecting a first site collection from the list of one or more site collections matching the one or more search requirements;
• receiving information about the first site collection;
• receiving an indication to perform a search for a site with a context of the first site collection;
• receiving a site selector user interface (UI) to perform a search for the site;
• entering one or more search requirements for searching for the site;
• receiving from the content management application a list of one or more sites matching the one or more search requirements for the site, wherein the content management application deletes orphaned databases;
• selecting a first site from the list of one or more sites matching the one or more search requirements for the site;
• receiving an indication to perform a search for a document library within the context of the first site;
• receiving a list selector UI to perform a search for the document library;
• and
• entering one or more search requirements for searching for the document library.