AW: DROP CONNECTIONS OF DATABASE

Fabian Kneubuehl support at ysd.ch
Wed Mar 21 01:36:16 CDT 2012


Hi Ruslan

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!

Thanks for thinking about
Fabian


-----Ursprüngliche Nachricht-----
Von: valentina-bounces+f.kneubuehl=ysd.ch at lists.macserve.net
[mailto:valentina-bounces+f.kneubuehl=ysd.ch at lists.macserve.net] Im Auftrag
von Ruslan Zasukhin
Gesendet: Dienstag, 20. März 2012 19:18
An: valentina at lists.macserve.net
Betreff: Re: DROP CONNECTIONS OF DATABASE

On 3/20/12 4:36 PM, "Fabian Kneubuehl" <support at ysd.ch> wrote:

Hi Fabian,

>   Call myServer.UnregisterDatabase(DBName)

Just in case -- try here  SQL command  UNREGISTER DATABASE

Double check name of db you unregister ...


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


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina



More information about the Valentina mailing list