- No user is able to log in to the vault, and everyone gets an error message “Error accessing the database”:
- No changes have been made on the Database & Archive Servers, all the connections are OK, no changes to SQL server
Trouble shooting:
- 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 …”
- Run query:
select log_reuse_wait_desc, [name]
from sys.databases - Run query to check log space of JMC-PDM database:
DBCC SQLPERF(logspace) - Run query to truncate the database:
Declare @name sysname
set @name= ‘JMC-PDM’
Backup LOG @name WITH truncate_only; - Run query again to check log space used:
DBCC SQLPERF(logspace)
The results show that Log space used for JMC-PDM is > 100%, that’s why the problem