Sometimes the backup fails on our sqllserver installation.
after this error you find a dumpfile.
the error in the log is:
Executed as user: NT AUTHORITY\SYSTEM. DBCC execut
ion completed. If DBCC printed error messages, con
tact your system administrator. [SQLSTATE 01000] (
Message 2528) BACKUP DATABASE is terminating abno
rmally. [SQLSTATE 42000] (Error 3013) A system as
sertion check has failed. Check the SQL Server err
or log for details [SQLSTATE HY000] (Error 3624)
Location:# opentape.cpp:1230 Expression:# !pNext
!foundMatch SPID:## 125 Process ID:# 192 [SQLSTA
TE 01000] (Error 3624). The step failed.
This is our configuration:
This file is generated by Microsoft SQL Server
version 9.00.2047.00
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is HP - 2
Current time is 12:02:27 01/02/07.
4 Intel x86 level 6, 2666 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack1.
Memory
MemoryLoad = 18%
Total Physical = 16383 MB
Available Physical = 13372 MB
Total Page File = 28131 MB
Available Page File = 12568 MB
Total Virtual = 2047 MB
Available Virtual = 301 MB
Please help.
Are you trying to copy the backup to another location?
What is the privilege for the SQL Server Agent account, as I can see you are using Local system account. Try to schedule the backup manually in this case and also check what kind of other jobs are scheduled on SQL Server and also on the operating system side, such as antivirus checks etc.
No comments:
Post a Comment