468,293 Members | 1,841 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,293 developers. It's quick & easy.

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
Mar 19 '08 #1
1 3334
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" <da********@shaw.cawrote in message
news:87**********************************@s13g2000 prd.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

Mar 19 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

48 posts views Thread by Joseph | last post: by
1 post views Thread by alex | last post: by
1 post views Thread by Norbert Munkel | last post: by
12 posts views Thread by Berj | last post: by
5 posts views Thread by Andy Davis | last post: by
2 posts views Thread by Joachim Klassen | last post: by
4 posts views Thread by Kittikun | last post: by
6 posts views Thread by michael.spoden | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.