When trying to check GuardianEdge Reports in GE Manager Console , getting “Database Access Error” , The transaction log for database 'GEMSDb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
On the SQL server , gets following event
Error Event ID: 9002
Message: The transaction log for database 'GEMSDb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
Backup transaction log
When the transaction logs are full, you must immediately back up your transaction log file. While the backup of your transaction log files is created, SQL Server automatically truncates the inactive part of the transaction log. The inactive part of the transaction log file contains the completed transactions, and therefore, the transaction log file is no longer used by SQL Server during the recovery process. SQL Server reuses this truncated, inactive space in the transaction log instead of permitting the transaction log to continue to grow and to use more space.
To Backup a transaction log
1.In SQL Server Management Studio, Expand
GEMSDb database, point to
Tasks, and then click
Back Up. The
Back Up Database dialog box appears.
Database list box, verify the database name.
4.Verify that the recovery model is either
Backup type list box, select
Set Autogrowth to "Unrestricted"
1.In SQL Server Management Studio, right click on
GEMSDb the database.
2.Go to Properties.
3.Then go to the Files section.
4.Click on both the data and log autogrowth column (Click the ...)
Unrestricted File Growth”
Note : This also applies for the error : "Transaction log for database SEEMDb is full"
Running GuardianEdge or Symantec Endpoint Encryption
Imported Document ID: TECH158711
Subscribing will provide email updates when this Article is updated. Login is required.