These are copied from the ArchivingCDRReporter read me…
The following are some user specific SQL query samples that are intended to guide you through extracting relevant reporting user or time range specific information from the Archiving/CDR Database. The general usage queries are already added as part of the tool.
Using my previous employers standard SQL build caused some issues installing a new OCS pool. The 2 errors are related to the articles below.
Security Account Delegation
http://msdn.microsoft.com/en-us/library/aa905162%28SQL.80%29.aspx
Shrinking your model DB size.
http://support.microsoft.com/default.aspx/kb/307487