I know searching the site-wide facility allows you to search the blog as well, but I am using the SP blog as a way of feeding a knowledge management system. The search facility added as a webpart on the page will search various sources (eg: bing, shared documents folder, etc), but I would also like to search the blog facility.
Is there a way of doing this?
I also realise that SP stores its data in a database and I guess I'd be able to interrogate that to obtain the blog content.
Does anyone know where the database is located? Currently I am using SharePoint Foundation locally on my machine.