Now I meet a question when backup SQLserver7.0,It prompt me the following attachment and I check the SQLserver log :"Using 'xpsql70.dll' version '1998.11.13' to execute extended stored procedure 'xp_msver'.
Error: 9002, Severity: 17, State: 2,The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.."
Pls help me. Thanks with best regards.Error: 9002, Severity: 17, State: 2,The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.."
I am receiving this error when attempting a restore of a 7.0 database. The log is set to autoextend. Immediately following these messages I am getting a "write failure on backup device".
Anyone experiencing these problems? Could it be that tempdb's log file has been corrupted? Any help with this would be greatly appreciated.
Showing posts with label sqlserver7. Show all posts
Showing posts with label sqlserver7. Show all posts
Tuesday, March 20, 2012
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.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).sql
"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.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).sql
Subscribe to:
Posts (Atom)