BCM and Sql, in general

BCM uses Sql Server to manage its data. BCM asks Sql Server client software to connect it to its data using a string to identify the server and database. Sql manages everything else. Sql Server is a Windows NT service running on the same or another machine. BCM does not directly access the file where the database stores its data, Sql does that itself, although BCM does ask Sql to put the file in a folder owned by the user.

BCM does surface some database management features in its UI--e.g., asking Sql to create a new database, select another database, and backup or restore the database--but BCM doesn't have UI for every feature of Sql Server, like changing the physical location of the database file or moving it to another server.

To do any database operations that aren't in the BCM UI you need to use Sql Server directly.