Sign in to wikis by wetpaint

Sign in or

Managing Database File Size

Page Versions

Key: additions deletions

Showing 6 pages

	Date/Time	Made By	Edit Note	Type	Scope
	Oct 20 2011, 3:19 PM EDT	sdrevik		edit	1 word added 1 word deleted
Change: (AV22)(AVData)This script can run during normal polling, but should not be run at the same time as a database backup.(We have tested this task running every 6 minutes against a system doing minute View changes from previous version. (Word count: 661)
	Oct 20 2011, 2:51 PM EDT	sdrevik		edit	64 words added
Change: We have tested this task running every 6 minutes against a system doing minute polls without any significant interference. The system will 'buffer up' polling View changes from previous version. (Word count: 661)
	Oct 20 2011, 1:13 PM EDT	sdrevik		edit	172 words added
Change: SQL maintains a series of referential indexes to quickly find data. While SQL does some work to try to 'recycle' this space, it's not very View changes from previous version. (Word count: 598)
	Oct 14 2011, 8:36 PM EDT	sdrevik		edit	261 words added 75 words deleted
Change: , make sure that your Scheduled Tasks include a task called "Purge Journal Messages." It should run once per day and purge messages roughly older View changes from previous version. (Word count: 423)
	Jul 14 2010, 9:48 AM EDT	sdrevik		edit	224 words added
Change: The FULL_RECOVERY mode is useful because it allows the database to be 'rolled back' to any point in time (but, of course, the files have to be intact- it's no help when trying to do a disaster / file loss recovery). However, if we are doing regular backups, View changes from previous version. (Word count: 227)
	Jul 14 2010, 9:42 AM EDT	sdrevik		create	No content added or deleted.
Change: Created by sdrevik Jul 14 2010, 9:42 AM EDT for: no reason given