Tuesday, January 20, 2009

“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)

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

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

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

Monday, October 27, 2008