Timed Compaction

[pat_nospam]

Timed Compaction, how?

I've deployed a database recently, but want to schedule a compact and repair to run in the night before the backup - how do I accomplish this?

Thanks again

 

[neileg]

Why not set it to compact on close? Then when the last user logs out, the compact will happen.

 

[haj1503]

Hi pat_nospam,

Why not you try this sample db that I've created, this db used in my office so far OK

 

[namliam]

Personaly i would use the AT planner for that one....

Regards

 

[namliam]

By the By Hay,

You are doing a dbengine.compact... Why? and why not a command line compact which would save the rename bit....

Regards