Putting some notes in here that relate to SQL Server specific isssues.

On the primary MS SQL server provided by the UHL, we have configured the following:

create database i2b2metadata create database i2b2demodata create database i2b2workdata create database i2b2metadata2 create database i2b2demodata2 create database i2b2workdata2 create database i2b2_b1_metadata create database i2b2_b1_data create database i2b2_b1_workdata create database i2b2hive create database i2b2pm

Links

This is useful on rebuilding indexes: ​http://www.sqldbpros.com/2010/11/sql-server-rebuild-indexes-the-fastest-way/