I need to backup the databases but when someone is connected to a database,
I cannot back it up.
Is there any way to tell if the files are in use?
Is there any way to disconnect all the users so that I can back up the
I don't want to stop the service because then people couldn't read either.
Also, Locking the tables is not really feasable because it blocks until it
gets the lock and if someone has a persistent connection, it may never
return. Thus, the databases would not be backed up. So, disconnecting the
users would be preferable.