DROP CONNECTIONS OF DATABASE

Ivan Smahin ivan_smahin at paradigmasoft.com
Mon Mar 19 07:19:07 CDT 2012


On Mar 17, 2012, at 2:12 PM, Fabian Kneubuehl wrote:

> DROP CONNECTIONS OF DATABASE … would be very handy if the part OF DATABASE was optional: DROP CONNECTIONS [OF DATABASE …] AND if VServer closes all DB-files in that case. So it would  be possible e.g. to replace a DB by a backup! I tried the API call .Restart  but that simply shuts down the Windows service (no restart).
>  

> DROP CONNECTIONS OF DATABASE


means - close all connections which use that database. After dropping last connection - db will be closed and you can replace db files without restarting vServer.

> Or does anybody know of a method to replace ValentinaFiles in use (Windows 7) without restarting the server
>  
> Regards Fabian
>  
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120319/2a4f1887/attachment.html>


More information about the Valentina mailing list