472,125 Members | 1,533 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,125 software developers and data experts.

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 3459
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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.