I there a backup method to automatically disconnect existing DB users and
prevent
additional logins during backup.
Thanks,
Ed
Hi
No. You need to write a script to KILL the users.
You do not need to kick users off the server, unless you have a good reason
to do it as Backups can be run under full usage..
Also, if the client applications are not well behaved, they might post
partial transactions.
Regards
Mike
"coenzyme" wrote:
> I there a backup method to automatically disconnect existing DB users and
> prevent
> additional logins during backup.
> Thanks,
> Ed
Showing posts with label disconnect. Show all posts
Showing posts with label disconnect. Show all posts
Friday, February 24, 2012
backup management
Labels:
andpreventadditional,
automatically,
backup,
database,
disconnect,
existing,
logins,
management,
method,
microsoft,
mysql,
oracle,
server,
sql,
users
backup management
I there a backup method to automatically disconnect existing DB users and
prevent
additional logins during backup.
Thanks,
EdHi
No. You need to write a script to KILL the users.
You do not need to kick users off the server, unless you have a good reason
to do it as Backups can be run under full usage..
Also, if the client applications are not well behaved, they might post
partial transactions.
Regards
Mike
"coenzyme" wrote:
> I there a backup method to automatically disconnect existing DB users and
> prevent
> additional logins during backup.
> Thanks,
> Ed
prevent
additional logins during backup.
Thanks,
EdHi
No. You need to write a script to KILL the users.
You do not need to kick users off the server, unless you have a good reason
to do it as Backups can be run under full usage..
Also, if the client applications are not well behaved, they might post
partial transactions.
Regards
Mike
"coenzyme" wrote:
> I there a backup method to automatically disconnect existing DB users and
> prevent
> additional logins during backup.
> Thanks,
> Ed
Labels:
andpreventadditional,
automatically,
backup,
database,
disconnect,
existing,
logins,
management,
method,
microsoft,
mysql,
oracle,
server,
sql,
users
backup management
I there a backup method to automatically disconnect existing DB users and
prevent
additional logins during backup.
Thanks,
EdHi
No. You need to write a script to KILL the users.
You do not need to kick users off the server, unless you have a good reason
to do it as Backups can be run under full usage..
Also, if the client applications are not well behaved, they might post
partial transactions.
Regards
Mike
"coenzyme" wrote:
> I there a backup method to automatically disconnect existing DB users and
> prevent
> additional logins during backup.
> Thanks,
> Ed
prevent
additional logins during backup.
Thanks,
EdHi
No. You need to write a script to KILL the users.
You do not need to kick users off the server, unless you have a good reason
to do it as Backups can be run under full usage..
Also, if the client applications are not well behaved, they might post
partial transactions.
Regards
Mike
"coenzyme" wrote:
> I there a backup method to automatically disconnect existing DB users and
> prevent
> additional logins during backup.
> Thanks,
> Ed
Labels:
additional,
automatically,
backup,
database,
disconnect,
existing,
logins,
management,
method,
microsoft,
mysql,
oracle,
prevent,
server,
sql,
users
Subscribe to:
Posts (Atom)