Page 1 of 1

SP/FC - HOW TO DELETE THE ARCHIVE FILE, why to delete

Posted: Sun Nov 01, 2009 5:08 pm
by Leo
HOW TO DELETE THE ARCHIVE FILE, why to delete
The key is to DELETE the archive before it drives your SQL database over the 2gig limit for MSDE.
IF THE ARCHIVE IS NOT DELETED AND THE DATABASE HITS 2GIG THE SYSTEM WILL STOP



WHEN IS THE HISTORY FILE MOVED TO THE ARCHIVE FILE
Its moved daily, weekly,monthly per -> Admin-> parameter form -> Settings, (monthy is just fine))

-----------------------------------------------------------------
HOW TO DELETE THE ARCHIVE FILE
Admin-> parameter form -> Clear Archive
Hit the show date, this will show the dates held within the Achive.
choice the start and stop date, then delete.

Make the end date two months ago.
And the start date older then the (Earliest date in the current archive DB)

Image