AW: DROP CONNECTIONS OF DATABASE

[Ruslan Zasukhin]

On 3/21/12 8:36 AM, "Fabian Kneubuehl" <support at ysd.ch> wrote:

Hi Fabian,

> I cannot reopen Mantis ID 3600 so I write this addendum here:
> 
> Please think about going one step further:
> 
> If you combine:
> 
> CLONE DATABASE [SKIPERRORS]
> If VServer DROP ALL CONNECTIONS
> Close files
> Delete files
> Rename clone of DB
> ReOpen files
> ev. if VServer reestablish connections
> 
> You will have a perfect REPAIR command!

No.

Because this will be yet long.

REPAIR in ideal should touch only broken things.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]