Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2007
    Posts
    66

    Unanswered: Backup And Load At The Same Time

    Hi ,


    I have a load script that runs every hour and loads the files every hour into the tables. This script is running perfectly well except that it is failing whenever backup is being taken.It is failing with a deadlock error.Cant we do a backup and load at the same time.Below are the error messages::

    SQL0911N The current transaction has been rolled back because of a deadlock
    or timeout. Reason code "68". SQLSTATE=40001

    SQL0911N The current transaction has been rolled back because of a deadlock
    or timeout. Reason code "2". SQLSTATE=40001

  2. #2
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    You cannot have any one connected if you are doing OFFLINE backup. If you are doing online backup , it is not recommonded to do loads while running the backup

  3. #3
    Join Date
    Jun 2007
    Posts
    66
    Its an online backup..So do you say that there is no way that online backup and laod can happen at the same time on a DB. I guess there should be some workaround for that..Any help would be appreciated.

  4. #4
    Join Date
    Mar 2006
    Posts
    104
    Hi,
    If online backup occur at a fixed time, then change schedule to skip load during that time.

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •