Tuesday, February 23, 2010

SharePoint 2010 Farm Databases

So I was just installing a new SharePoint 2010 Enterprise RC farm just recently and while I was waiting for the services page to finish creating the services, I took a quick peek at the DB server to figure what was going on in the backend. I have installed the SP 2010 beta version a couple of times before, but have to admit never looked in the database to see what was going on.

It appears that all the services are not segregated in their own databases, instead of the SSP database managing the services as in the 2007 version. Here is a snapshot of the available databases. DBA's, be forewarned :).

Here are the two screenshots. The first shows the Farm configuration wizard after the services have been configured. The second shows the databases that have been created.