cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
982
Views
0
Helpful
6
Replies

Shrink TEO Process DB

briaho
Beginner
Beginner

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.

3 Accepted Solutions

Accepted Solutions

derevan
Enthusiast
Enthusiast

If it is SQL Server, try the following:

alter database teoprocess
set recovery simple;
go

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

View solution in original post

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.

View solution in original post

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.

View solution in original post

6 Replies 6

derevan
Enthusiast
Enthusiast

If it is SQL Server, try the following:

alter database teoprocess
set recovery simple;
go

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

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.

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.

Von,

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

Regards,

Brian

Mike,

Thanks for the info. That helps.

Regards,

Brian

Derek,

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

Thanks.

Brian

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: