How To: Perform a SQL backup of bt-LogAnalyzers Databases

From burstekwiki
Jump to: navigation, search

How to perform a bt-LogAnalyzer SE™ Database backup?

Note Note: These steps require Microsoft SQL Server Management Studio. This can be downloaded for free from Microsoft here if you do not have the full version of SQL. If you use the Express version of SSMS you will not be able to automate the backup process however.

Note Warning: Please ensure that a 'Settings Export' is performed immediately before or after the database backups to ensure information is in sync if a restore is ever needed.

  1. Open the Microsoft SQL Server Management Studio and Connect to the SQL server where bt-LogAnalyzer SE™ is installed
  2. Expand the 'Databases' container object
  3. Right click on the 'LAEE_Data' database and select 'Tasks -> Backup'
  4. Make the appropriate selections for your environment and click 'OK'
  5. Once the backup completes, perform the same steps above for the following 2 databases:
    1. LAEE_Reports
    2. LAEE_Settings
  6. If you are using the SSMS application that comes with SQL Server, you may want to use the Maintenance Plan Wizard to create Automatic Periodic Database Backups
Personal tools