Shrink TEO Process DB

[briaho]

Hi,

On CPO, we set db gromming to minimal and also turn off archival log but TEO Process DB remains huge at 97 GB. Is there a best practice on how we gracrfully purge old data / archives out of this db?

Thanks for your input.

[derevan · Accepted solution]

If it is SQL Server, try the following:

alter database teoprocess
set recovery simple;
go

dbcc shrinkfile ('TEOProcess_log.ldf',1000);
go

[Von Jones · Accepted solution]

Configuration of grooming in the product natively should autyomatically handle the purging of the data.  The DB file size may remain at its highest point though with much of the space in the file is not used.  Generally you should not need to perform SQL actions to handle grooming.  If you have a big surge of activity at sopme point this command can shrink the file back down.

[meisenst · Accepted solution]

Make sure the recovery mode in your database properties is set to Simple.

Often, this will free up huge amounts of space as logs are purged automatically.

[briaho]

Von,

Thanks, this worked! We were able to reduce the size of our Process db.

Regards,

Brian

[briaho]

Mike,

Thanks for the info. That helps.

Regards,

Brian

[briaho]

Derek,

We tried this on customer's db and we were able to reduce db size by 55%!!

Thanks.

Brian