AW: DROP CONNECTIONS OF DATABASE

[Ruslan Zasukhin]

On 3/21/12 7:11 PM, "Robert Brenstein" <rjb at robelko.com> wrote:

> On 3/21/12 8:36 AM, "Fabian Kneubuehl" <support at ysd.ch> wrote:
> 
>>  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!
> 
> If those steps are combined and provided as a command on the server,
> I would suggest to call it RESCUE or RECREATE or something like that.
> REPAIR should be reserved for a utility which fixes only problem
> areas, should such utility ever become available.

Agree with Robert here.


Fabian, why you ask wrap this step of steps into our own command?
Because:
A) just to simplify life of developer?
B) there is some very important step here which devloper cannot do self ?



-- 
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]