Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Exclamation Unanswered: backup db occurs error

    Today I backup the SQLServer7.0,it prompt me error:
    "Microsoft SQL-DMO(ODBC SQLState:42000)
    Backup,CHECKALLOC,bulk copy,SELECT INTO,and file manipulation(such as CREATE FILE) operations on a database must be serialized.
    Reissue the statement after the current backup,CHECKALLOC,or file manipulation operation is completed.
    Backup or RESTORE OPERATION terminating abnormally."

    Pls help me. Thanks with best regards.

  2. #2
    Join Date
    Oct 2002

    Re: backup db occurs error

    The error simply means that at the time the backup dump operation was attempted it could not be executed (because of other activity in progress).

    Often, this is a result of attempting to run backups when maintenance is in progress.

    If that is the issue try to run or schedule backup dumps at times when DB maintenance is complete (not in progress).

Posting Permissions

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