[Technical Notice] Solution to GV-ASManager’s Database Overload, Compact database, Recordset error when deleting a user

[alexhon]

Article ID: GV4-17-01-05-al
Released Date: 01/05/2017
Revision Date: 02/17/2017

Applied to
GV-ASManager

Symptom
When the size of GV-ASManager’s database exceeds 2 GB, even though the overloaded log files will be compressed automatically, other devices can lose connection to GV-ASManager during the compression process. Or Getting recordset error when deleting a user or modifying a card

Solutions
Depending on your database usage, there are solutions to this issue: one is to install Microsoft SQL Server Express and the other is to compact the database.

Solution1: Installing Microsoft SQL Server Express
Microsoft SQL Server 2014 Express is a free version of SQL Server with a maximum database size of 10 GB. If you are using more than 2 GB of database space, it is recommended that you install and create a Microsoft SQL Server to be the database of GV-ASManager for additional data allowance.

1. Go to Microsoft Download Center and search for the SQL Server 2014 Express Edition.
2. Locate the SQL Server 2014 Express Edition web page and download the executable file.
3. Run the executable file, and follow the on-screen instructions to install on your local computer.

Creating a Microsoft SQL Server
After installing the SQL Server Expression Edition, you can now create a Microsoft SQL Server.

1. Run ASDBManager.exe from the program folder to access the Database Tools.
2. Click the ASManager Database Setting button on the Database Tools dialog box.

   

   Screenshot_1.jpg (27.63 KiB) Viewed 2131 times

3. Click the Setup MDB/MSSQL Database for ASManager button. This dialog box appears.

   

   Screenshot_2.jpg (22.84 KiB) Viewed 2131 times

4. Select Microsoft SQL Server to create a Microsoft SQL Server.
   • Under SQL Database Setting, type IP address or domain name of the SQL server in the Data Source field, and select its authentication way.
   • Under Database, name the databases for Configuration files and Log files that will be created on the SQL server separately.
   • Click Test Connection to test the connection to the SQL server.
   • Click OK. The databases are created in the SQL server

Solution2: Compacting the Database
If you only require approximately 2 GB of database data storage or less, it is recommended that you regularly compact the database to a smaller size so your GV-ASManager can keep running at its optimal level.

1. Run ASDBManager.exe from the program folder to access the Database Tools.
2. Click the ASManager Database Setting button on the Database Tools dialog box.
3. To set up a schedule to automatically compact the database, click Schedule on the right-hand side of Compact Database.

   

   Screenshot_3.jpg (26.52 KiB) Viewed 2130 times

4. Select Enable to specify the time for database compression.

   

   Screenshot_4.jpg (19.37 KiB) Viewed 2130 times

   • Every Day: Type the exact number of days to perform database compression every time.
   • Every Week: Select a specific day of the week to perform database compression.
   • Every Month: Select a specific day of the month to perform database compression.
   • Start Time: Define a specific time of the day to begin the compression process.