How do I backup my database?

Below are the procedures for backing up data from PostgreSQL and Microsoft SQL Server databases.

Note: Before starting the backup process, stop the Log360 service.

Database backup procedures for PostgreSQL:

Take a backup of the existing Log360 PostgreSQL database by creating a ZIP file of the contents available in <Log360 home>\pgsql directory and save it as pgsql_backup.zip in <Log360 home> directory.

Database backup procedure for Microsoft SQL Server:

• Find the current location of the data and log file for the database  log360  by using the following commands:
  • use log360
  • go
  • sp_helpfile
  • go
• Detach the database using the following commands:
  • use master
  • go
  • sp_detach_db 'log360'
  • go
• Backup the data file and log file from the current location <MSSQL Home>\data\log360.mdf and <MSSQL_Home>\data\log360_log.LDF to the new location <New Location>\log360.mdf and <New Location>\log360_log.LDF.

• Re-attach the database and point to the old location by using the following commands:
  • use master
  • go
  • sp_attach_db 'log360','<MSSQL Home>/data/log360.mdf', '<MSSQL Home>/data/log360.mdf'
  • go