Is it possible or recommended to purge old database files raaaaaaaa.chg files we have are from 2002 can we purge these in let say a seperate drive folder and if so what is the best practice for such a move and are there any ramifications to such a process. Any advice on this is much appreciated. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
purging database files to another drive.. 1
- Thread starter jcthomas
- Start date
-
1
- #2
speshalyst
IS-IT--Management
Hi,
Please refer to the link below
rxxxxxxx.chg – Velocis uses a change log to record each change made to a database during a transaction. A complete change log is the logical concatenation of all change log files written since the last backup. Using a process called “change log cycling” the server uses a new change log file when the current one reaches the maximum size (default 2,000,000 bytes) set by the MaxChangeLogSize configuration parameter found in velocis.ini.
So it can be safely said that you can purge the old logs from the database..
cheers
So it Shall be Written!
So it Shall be Done!!
Please refer to the link below
rxxxxxxx.chg – Velocis uses a change log to record each change made to a database during a transaction. A complete change log is the logical concatenation of all change log files written since the last backup. Using a process called “change log cycling” the server uses a new change log file when the current one reaches the maximum size (default 2,000,000 bytes) set by the MaxChangeLogSize configuration parameter found in velocis.ini.
So it can be safely said that you can purge the old logs from the database..
cheers
So it Shall be Written!
So it Shall be Done!!
- Status
Similar threads
- Locked
- Question