Data Storage in SharePoint 2007

Question:
“Where is the data and the documents stored when I create a document library in SharePoint 2007?”

Answer:
The meta-data (library columns) and the files themselves (BLOBs) are stored in the SQL Server database associated with the specific web application.

The databases can be viewed and managed in Central Admin -> Application Management -> Content Databases.