|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
19/03/2008, 18h57
|
#1 |
Messages: n/a
Hébergeur: |
Can users be connected during a SQL backup?
We have a existing backup, re-index job that runs at night on an
existing database that is now accessed by web users 24/7. Problem is that one of the steps is to kill all users before backup starts so it kills any transactions that are happening at that time question is... Can users be connected during a backup? Will removing the kill users step slow the backup alot? any other suggestions would be appreciated. thanks |
|
|
19/03/2008, 19h19
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Can users be connected during a SQL backup?
esource,
Backups run fine with people logged in and working. Users will not slow the backup a lot much and backups should (in fact) be done without requiring clearing out the users. RLF "esource" <darrenpaul@shaw.ca> wrote in message news:872bbd07-0175-43fe-acd8-2678f84c9422@s13g2000prd.googlegroups.com... > We have a existing backup, re-index job that runs at night on an > existing database that is now accessed by web users 24/7. > Problem is that one of the steps is to kill all users before backup > starts so it kills any transactions that are happening at that time > question is... Can users be connected during a backup? Will removing > the kill users step slow the backup alot? > any other suggestions would be appreciated. > thanks |
|
|
|
| Outils de la discussion | |
|
|
