September 24, 2015 at 1:30 pm
I have a SQL backup job created by a maintenance plan that began failing after a power outage resulting in exception logs and dump files. The databases are in 'Simple' recovery model and the backups are 'Full' backups. The DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS command returned no errors.
I discovered after stopping/starting the SQL database engine service that the backups complete successfully once or twice, but then begin failing again due to same reason. So, I am having to stop/start the SQL service each day to get the backups to complete.
Using this version:
Microsoft SQL Server 2014 - 12.0.2000.8 (X64) Feb 20 2014 20:04:26 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
Failure reason from Error Log:
Failed: (-1073548784) Executing the query "BACKUP DATABASE [Color] TO DISK = N'\\\\BackupFolder..." failed with the following error: "BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Exception Access Violation:
03/25/15 15:04:30 spid 70 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 00000000AF6EBB10 at 0x00000000013B6958
Portion Dump:
Memory
MemoryLoad = 87%
Total Physical = 8191 MB
Available Physical = 1024 MB
Total Page File = 16381 MB
Available Page File = 7981 MB
Total Virtual = 8388607 MB
Available Virtual = 8372831 MB
***Stack Dump being sent to E:\Program Files\Microsoft SQL Server\MSSQL12.APPS\MSSQL\LOG\SQLDump0105.txt
SqlDumpExceptionHandler: Process 5072 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Error: 3041
2015-09-23 19:00:52.55 Backup Error: 3041, Severity: 16, State: 1.
2015-09-23 19:00:52.55 Backup BACKUP failed to complete the command BACKUP DATABASE Color. Check the backup application log for detailed messages.
2015-09-23 19:00:52.63 spid68 ***Stack Dump being sent to E:\Program Files\Microsoft SQL Server\MSSQL12.APPS\MSSQL\LOG\SQLDump0098.txt
2015-09-23 19:00:52.63 spid68 SqlDumpExceptionHandler: Process 5072 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
September 24, 2015 at 2:01 pm
Access violations are memory-related (reading or writing memory that belongs to another process or similar). Can you do a memory test of the server? Bios or other tool?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 24, 2015 at 2:08 pm
Thanks, Gail. I'll go talk to the server admin people and then report back to you what they discover.
September 25, 2015 at 4:48 am
If you don't come right, log a call with MS support. They have the tools to read and interpret stack dumps.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2015 at 5:02 am
Gail, I failed to include an important piece of information in my original post. This SQL Server is running on a VM machine. The server admin group stopped/started the VM machine and then moved the VM machine to a different host machine. Since then the backups have completed successfully. Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply