Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database monitoring » SQL Anywhere Monitor » Backing up the Monitor

 

Restoring a backup copy of the Monitor database

You can replace the Monitor database with a backup copy.

Prerequisites

You must have a valid backup copy of the Monitor database.

 Task

  1. Stop the Monitor, if it is running.

  2. From your backup directory, copy the samonitor.db database file and samonitor.log transaction log file.

  3. Paste these files into the directory where the current Monitor database and transaction log file are located. When prompted, overwrite the existing files.

    The default locations of the version 16.0 Monitor database files are listed in the following table:

    Operating system Monitor directory

    Windows XP (installed with SQL Anywhere)

    		 
    C:\Documents and Settings\All Users\Documents\SQL Anywhere 16\Monitor\samonitor.db
    Windows XP (installed on a separate computer) 
    C:\Documents and Settings\All Users\Documents\SQL Anywhere 16 Monitor\samonitor.db
    Windows Vista and later (installed with SQL Anywhere) 
    C:\Users\Public\Documents\SQL Anywhere 16\Monitor\samonitor.db
    Windows Vista and later (installed on a separate computer) 
    C:\Users\Public\Documents\SQL Anywhere 16 Monitor\samonitor.db
    Linux (installed with SQL Anywhere) 
    /opt/sqlanywhere16/samonitor.db
    Linux (installed on a separate computer) 
    /opt/sqlanywhere16/samonitor.db

  4. Restart the Monitor.

Results

The database is restored from a backup copy.

Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0