Event ID 17137
Check if in the Microsoft SQL Server for the Citavi database, the Auto_Close option is enabled. If so, the database is closed each time and its resources are only released once there are no more user connections accessing the database. When a new connection is established, the database restarts automatically. This can cause performance issues for databases that are accessed frequently and can also lead to database corruption.
If AUTO_CLOSE is disabled, the server keeps the database in an open and ready state regardless of user activity.
Microsoft recommends leaving the AUTO_CLOSE option set to OFF if a database is accessed frequently.
In the Microsoft SQL Server Management Studios you can change the AUTO_CLOSE setting. There are two ways to do this:
A. Run the following SQL command:
ALTER DATABASE <Citavi database name> SET AUTO_CLOSE OFF
B. Make the change manually:
- Expand Databases.
- Right-click the Citavi database and select Properties.
- On the Database Properties window, switch to Options.
- Under More options add Automatic.
- Set the Auto_Close option to False, and then click OK.