I just noticed one of my databases is getting bigger and bigger despite an archiving agent which is supposed to move docs over 60 days old to an archive db every night.
It seems that the agent which used to work well is not deleting the document from the the db, nor is it copying any doc to the archive db. nevertheless the agent still sends out archiving report with a list of docs that have been allegedly archived.
Using a view that calculates the total size of docs in the view, I find the db only contains about 9 Gb of docs that are less than 60 days old. However, the db Properties -Info tab shows an utilisation of over 90% percent and a size of a whopping 39 Gb.
Can anyone tell me why the agent is no longer working ?
Where can I find docs that make up the remaining 30 Gb? Thanks in advance.
It seems that the agent which used to work well is not deleting the document from the the db, nor is it copying any doc to the archive db. nevertheless the agent still sends out archiving report with a list of docs that have been allegedly archived.
Using a view that calculates the total size of docs in the view, I find the db only contains about 9 Gb of docs that are less than 60 days old. However, the db Properties -Info tab shows an utilisation of over 90% percent and a size of a whopping 39 Gb.
Can anyone tell me why the agent is no longer working ?
Where can I find docs that make up the remaining 30 Gb? Thanks in advance.