Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

UI Tabs
UI Tab
titleMicrosoft SQL database using the SQL Server Management Studio

Microsoft SQL database using the SQL Server Management Studio 

  1. Login into the SQL Server Management Studio and expand the Databases folder
  2. Locate the Blancco reports database and expand the database (if you are unsure of the name of the database being used this can be found from the main.properties file in the following location "Program Files\Blancco\Blancco Management Console\apache-tomcat\webapps\ROOT\WEB-INF\classes" please note this is the default location and the location may differ on your system. In the main.properties file you will find the entry "database.url=" the value of this entry will include "database.name=" this is the database being used by the Management Console software")
  3.  Locate the Tables folder and expand it to display the database tables
  4. Locate the dbo.DATABASECHANGELOGLOCK and right-click to display the options menu
  5. Select Edit Top 200 rows which will display the content of the table
  6. You will see a row which has the LOCKED column set to True and values entered into the LOCKGRANTED (indicating when the lock was put into effect) and LOCKEDBY (indicating the system/user which locked the database) columns, you will need to delete this row to remove the lock.
UI Tab
titlePostgreSQL database using the pgAdmin tool

PostgreSQL database using the pgAdmin tool

  1. Open pgAdmin, expand "Servers" and then expand correct PostgreSQL installation/instance
  2. Expand "Databases", then locate and expand the database used with the Management Console and expand the database (if you are unsure of the name of the database being used this can be found from the main.properties file in the following location "Program Files\Blancco\Blancco Management Console\apache-tomcat\webapps\ROOT\WEB-INF\classes" please note this is the default location and the location may differ on your system. In the main.properties file you will find the entry "database.url=" the value of this entry will include "database.name=" this is the database being used by the Management Console software")
  3. Expand "Schemas" → "public" and locate the "Tables" folder and expand it to display the database tables
  4. Locate the "databasechangeloglock" and right-click to display the options menu
  5. Select "View/Edit Data" → "First 100 Rows" which will display the content of the table
  6. You will see a row which has the "locked" column set to "true" and values entered into the lockgranted (indicating when the lock was put into effect) and lockedby (indicating the system/user which locked the database) columns, you will need to delete this row to remove the lock.