Results Database Properties

If you created the Results database before running the DbMigrator, there are some settings that must be set manually in SQL server. Without these settings, the Results services may have issues.

See also, Create the Results Database Manually.

Database Properties

Options

·        Recovery Model - Simple

Notice
If you decide to use the Full option, be aware that your disk space may be consumed rapidly due to the way the Results database functions. Unless you have a very specific reason to use Full, the Simple option is sufficient (the CM4D software has built-in methods recovery options available for this database).

Other Options - Miscellaneous

·        Allow Snapshot Isolation - True

·        Is Read Committed Snapshot On - True

Setting the Database Properties

1.     Right-click the Results database.

2.     Select Properties.

3.     Go to the Options page.

4.     In the Recovery Model dropdown, select 'Simple'.

5.     In the Other Options section, scroll down to Miscellaneous.

a.     Set 'Allow Snapshot Isolation' to 'True'.

b.     Set 'Is Read Committed Snapshot On' to 'True'.

6.     Click OK.