You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Home > Miscellaneous > Taking Event Archives Offline
Taking Event Archives Offline
print icon

Overview

Access It! Universal will check the number of events in an archive once an hour. By default once the number of events reaches one million, a new archive will be created. The new event archive will be created with a name that represents the year, month, day, hour, minute, second that the archive was created.

The number of events that build up from activity may effect reporting if the SQL Server is not able to query the events in a timely manner, this number will vary between configurations. As more Events Archives are created more storage space on the hard drive will be used. This can be alleviated by taking the event archive offline and/or detaching the database from the SQL Server.

Taking Event Archives Offline

Taking an Event Archive Offline will remove the events of that archive from the report view, preventing the event archives from being included in the reports query.
Event Archives that are Offline will not be backed up by the Database Configuration Utility backups.

  1. Launch the Database Configuration Utility (Start | All Programs | Access It! Universal | Server Utilities)
  2. Click Connect
  3. Select the desired Event Archive
  4. Click Take Offline
    The Status will change to Offline.

Repeat steps 3 and 4 as needed.

Bringing Event Archives Online

Bringing an Event Archive Online will add the events of that archive to the report view, so the events can be queried.
Event Archives that are Online will be backed up by the Database Configuration Utility backups.

  1. Launch the Database Configuration Utility (Start | All Programs | Access It! Universal | Server Utilities)
  2. Click Connect
  3. Select the desired Event Archive
  4. Click Bring Online
    The Status will change to Online.

Repeat steps 3 and 4 as needed.

Detaching Event Archives

Detaching an Event Archive will allow the database files to be deleted or moved to an external storage media.

  1. In SQL Server Management Studio Object Explorer, connect to the instance of the SQL Server Database Engine
  2. Expand the instance
  3. Expand Databases, and select the name of the user database you want to detach
  4. Right-click the database name
  5. Point to Tasks
  6. Click Detach
    The Detach Database dialog box appears.
  7. Check the Drop Connections check box
    You cannot detach a database with active connections.
  8. When you are ready to detach the database, click OK
  9. Launch the Database Configuration Utility (Start | All Programs | Access It! Universal | Server Utilities)
  10. Click Connect
  11. Click Rebuild Views
  12. Close Database Configuration Utility
  13. Launch the Service Manager (Start | All Programs | Access It! Universal | Server Utilities)
  14. Click Stop Service
  15. Once the service is stopped, click Start Service

Attaching Event Archives

If a reported is needed on an Event Archive that was detached, the Event Archive will need to be attached and the report view will be need to be refreshed.

  1. In SQL Server Management Studio Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
  2. Right-click Databases
  3. Click Attach.
  4. In the Attach Databases dialog box, to specify the database to be attached, click Add; and in the Locate Database Files dialog box, select the disk drive where the database resides and expand the directory tree to find and select the .mdf file of the database
  5. Launch the Database Configuration Utility (Start | All Programs | Access It! Universal | Server Utilities)
  6. Click Connect
  7. Click Rebuild Views
  8. Close Database Configuration Utility
  9. Launch the Service Manager (Start | All Programs | Access It! Universal | Server Utilities)
  10. Click Stop Service
  11. Once the service is stopped, click Start Service

scroll to top icon