Creating a Microsoft SQL Server Content Data Store database manually
Only if you have a pressing reason to do so, create your SQL Server Content Data Store database manually by running the database scripts provided. In a demo or test environment, you can choose to create the State Store in the same database, by creating the State Store database tables as well. In a production environment, you can choose to create the State Store in its own database instead (for example, to improve performance), by running the State Store table creation commands separately.