How do I archive my change logs?

RSS

» How do I archive my change logs?

The change logs contain all changes made to the CAREWare database by users within the Client Tier. These logs are used as part of the audit feature of CAREWare. It is important to keep these logs, but if they are taking up to much space on the hard drive then you can detach and archive the oldest logs.You will need a SQL Manager such as Management Studio Express or Craig's SQL Manager to complete the following process.

NOTE: We recommend that you do not remove or detach the highest numbered change log attached to the database instance.

To detach a change log using Management Studio:

Open Management Studio and expand your CAREWare instance
Expand 'Databases' under your CAREWare database instance
Right click on the first CW_Change_Log_00XX you want to remove
Select "Tasks", then "Detach Database"
Check the checkboxes for Drop Connections and Update Statistics
Click "OK"

This procedure will detach the database. You can then go to the Microsoft SQL Server directory and move the detached change log to your archival destination.

To detach a change log using Craig's SQL Manager:

Open Craig's SQL Manager and register your database instance for CAREWare
Expand the database instance by clicking on the + sign
Right click on the CW_Change_Log_000X, where X is the last digit, and select "Detach Database"
Click "Yes" when prompted to detach the database.

This procedure will detach the database. You can then go to the Microsoft SQL Server directory and move the detached change log to your archival destination.

If you encounter the error "Cannot detach database "cw_change_log_000X because it is currently in use", then run the following query:

USE master;
ALTER DATABASE cw_change_log_000X
SET SINGLE_USER;

Then run the following query in order to detach the database:

sp_detach_db 'cw_change_log_000X'

Where X is the number of the change log.

Back to the Data Tier

Back to Frequently Asked Questions