Can users be connected during a SQL backup?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • esource
    #1

    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
    Tags: None
    • Russell Fields
      #2
      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@sha w.cawrote in message
      news:872bbd07-0175-43fe-acd8-2678f84c9422@s1 3g2000prd.googl egroups.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

        Comment

        Previous template Next
        Working...