The transaction log for database 'GEMSDb' is full

Article:TECH158711  |  Created: 2011-04-25  |  Updated: 2012-12-12  |  Article URL http://www.symantec.com/docs/TECH158711
Article Type
Technical Solution


Issue



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

 

Error



On the SQL server , gets following event
 
Error Event ID: 9002
Source: MSSQLSERVER
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

Environment



Running GuardianEdge or Symantec Endpoint Encryption


Solution



 

Method 1
 
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 Databases
2.       Right-click GEMSDb database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.
3.       In the Database list box, verify the database name.
4.       Verify that the recovery model is either FULL or BULK_LOGGED.
5.       In the Backup type list box, select Transaction Log.
 
 
Method 2
 
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 ...)
5.       Select “ Unrestricted File Growth

Note : This also applies for the error : "Transaction log for database SEEMDb is full"




Article URL http://www.symantec.com/docs/TECH158711


Terms of use for this information are found in Legal Notices