cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

719
Views
0
Helpful
6
Replies
briaho
Beginner

Shrink TEO Process DB

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

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

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

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

Content for Community-Ad
This widget could not be displayed.