Commerce Server and the MSCS_CatalogScratch Database and Maintenance.

Thanks to Charles Teague for providing some of the technical detail for this article. (Cross posted from http://blogs.msdn.com/b/finbar_ryan/archive/2012/05/02/commerce-server-and-the-mscs-catalogscratch-database-and-maintenance.aspx ) We’ll cover what the MSCS_CatalogScratch does in Commerce Server and how to maintain it either via VBScript or SQL Server Maintenance plans.   1) What’s the Catalog Scratch Database? The Catalog Scratch Database is a database…