Disabling the Auto Close feature in Ingest Database
This is only required for an upgrade of the Ingest database.
It is not required on a newly installed Ingest database since it will be set automatically during installation.
The Auto Close feature must be disabled to prevent the Ingest database from going offline automatically.
- Open and log in to Microsoft SQL Server Management Studio.
- Go to Databases and select ISDB.
-
Right-click on ISDB and
select Properties.
The Database Properties - ISDB window opens.
- Select the Options page.
- In the Automatic section, select Auto Close and set the value to False.
- Click OK. The Auto Close feature for Ingest Database is disabled.