Friday, February 24, 2012

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

No comments:

Post a Comment