InService Requirements for the SQL Database
After you install SQL and create the database, but before using the database, you must perform the following actions:
1. Run the following command: ALTER DATABASE <databasename> SET ALLOW_SNAPSHOT_ISOLATION ON
2. Set the log level to unlimited.
◦ Right Click on the DB Properties in SQL Server Management Studio.
◦ Click on > and select Unlimited.