By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,070 Members | 1,238 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,070 IT Pros & Developers. It's quick & easy.

Can users be connected during a SQL backup?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.