SharePoint databases – Conflicts
After I published my list with all SharePoint 2010 database information I decided to collate the information I can find on TechNet as of today(2011-10-25 – 25/10/2011 – 10/25/2011 
). The idea is to send it to the TechNet guys and Bill Baer to have a look.
Conclusion is that the information is inconsistent, as many other info about SharePoint in TechNet. Amazing that TechNet and MSDN are so prestigious for delivering all information the community needs but I am so used to find misleading information on TechNet that I often end up confirmind what there reading SharePoint related blogs. Not to mention all the situations where I can only find what I need in blogs.
Anyway, the comparison is attached and show conflicting information between all of them.
I was led to understand Bill’s material is the most up to date one so I am following his and therefore I suggest everybody doing so 
After a careful analysis you’ll see that Bill’s is really the most updated one as most things are changing from unsupported to supported. That basically means MS has tested it properly after SP1.
Here you go a list of all conflicts I identified:
| Mirror | Async | Log Shipping | ||||||
| Database | Bill | DB Types |
Bill | Db Types |
DR | Bill | DB Types |
DR Log |
| WSS_usage | yes | yes | no | yes | yes | yes | yes | yes |
| Application_Registry_server_DB_ | yes | yes | yes | no | no | yes | no | no |
| WebAnalyticsServiceApplication_StagingDB_ | yes | no | no | yes | yes | yes | yes | yes |
| WebAnalyticsServiceApplication_ReportingDB_ | yes | yes | no | yes | yes | yes | yes | yes |
| User Profile Service Application_SyncDB_ | yes | no | no | no | no | no | no | no |
| User Profile Service Application_SocialDB_ | yes | no | no | no | no | yes | no | no |
| Managed Metadata Service_ | yes | yes | yes | no | yes | yes | no | yes |
| PerformancePoint Service Application_ | yes | yes | yes | no | yes | yes | no | yes |
| DefaultPowerPivotServiceApplicationDB | yes | yes | yes | yes | no | 0 | yes | no |
Just to make it clear:
DbTypes refers to http://technet.microsoft.com/en-us/library/cc678868.aspx
DR refers to http://technet.microsoft.com/en-us/library/ff628971.aspx
Bill refers to Bill Baer’s information.
The question then is: What about Web Analytics. Has it ever been supported? Anyway, have a look the analysis and have your on conclusions
That’s a great analysis you have done..
Thank you!
I get very frustrated whenever I see those silly mistakes.
I love the product and I managed to get to a very nice position with it so I think documenting those things is the minimum I can do
Cheers!