“Error accessing the database”

Problem description:

1. No user is able to log in to the vault, and everyone gets an error message “Error accessing the database”:
   
2. No changes have been made on the Database & Archive Servers, all the connections are OK, no changes to SQL server

Trouble shooting:

1. When checking Administration --> Local settings --> Log File, the following error message occurs. Notice the text: “The transaction log for database JMC-PDM is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc …”




2. Run query:
   select log_reuse_wait_desc, [name]
   from sys.databases
   
   



3. Run query to check log space of JMC-PDM database:
   DBCC SQLPERF(logspace)

The results show that Log space used for JMC-PDM is > 100%, that’s why the problem


4. Run query to truncate the database:
   Declare @name sysname
   set @name= ‘JMC-PDM’
   Backup LOG @name WITH truncate_only;


5. Run query again to check log space used:
   DBCC SQLPERF(logspace)