July 3, 2014 at 7:43 am
My Database backup is not working in SQL 2014 RTM version. It works fine on SQL Server 2008 R2.
All databases are in Simple recovery model. Not sure what might be the issue. I'm admin for SQL instance and on the box.
DECLARE @BackupFile1 varchar(max)
SET @BackupFile1 = 'E:\MSSQL\Bak\DailyBackups\MSDB\MSDB1_' + REPLACE(REPLACE(REPLACE(CONVERT(varchar,GETDATE(), 112),'-',''),':',''),' ','') + '.BAK'
BACKUP DATABASE MSDB TO
DISK = @BackupFile1
WITH NOFORMAT, NOINIT, NAME = N'MSDB-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, COMPRESSION,MAXTRANSFERSIZE = 4194304, STATS = 10
Error:
Msg 3013, Level 16, State 1, Line 25
BACKUP DATABASE is terminating abnormally.
July 3, 2014 at 7:48 am
Did you look in the error logs? It will usually have some more detailed information about what the problem is.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 3, 2014 at 8:03 am
Backups work in 2014, so we'll need more information. I would suggest you install the cumulative updates though. They fix some pretty serious bugs.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 3, 2014 at 8:16 am
Never seen like this before. Looks like everytime DB Backup is attempted, a SQL Dump is getting created.
Date,Source,Severity,Message
07/03/2014 07:12:31,Backup,Unknown,BACKUP failed to complete the command BACKUP DATABASE SDStat. Check the backup application log for detailed messages.
07/03/2014 07:12:31,Backup,Unknown,Error: 3041<c/> Severity: 16<c/> State: 1.
07/03/2014 07:12:31,spid126,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
07/03/2014 07:12:29,spid126,Unknown,[INFO] Identity Begin End | State Result Error Speculate Prepared LazyCommit ReadOnly | Transaction Database ThreadId | ReadSet WriteSet ScanSet Savepoint LogSizeRq | CommitDep TotalComm Dependent 0 Dependent 1 Dependent 2 Dependent 3 Dependent 4 Dependent 5 Dependent 6 Dependent 7 | Area Location |
07/03/2014 07:12:19,spid126,Unknown,Stack Signature for the dump is 0x000000003A4041F2
07/03/2014 07:12:19,spid126,Unknown,00007FFB02294629 Module(ntdll+0000000000074629)
07/03/2014 07:12:19,spid126,Unknown,00007FFB020E16AD Module(KERNEL32+00000000000016AD)
07/03/2014 07:12:19,spid126,Unknown,00007FFAEECF3558 Module(sqldk+0000000000023558)
07/03/2014 07:12:19,spid126,Unknown,00007FFAEECF3246 Module(sqldk+0000000000023246)
07/03/2014 07:12:19,spid126,Unknown,00007FFAEECF38F0 Module(sqldk+00000000000238F0)
07/03/2014 07:12:19,spid126,Unknown,00007FFAEECF36FF Module(sqldk+00000000000236FF)
07/03/2014 07:12:19,spid126,Unknown,00007FFAEECD45B6 Module(sqldk+00000000000045B6)
07/03/2014 07:12:19,spid126,Unknown,00007FFAEECD47B4 Module(sqldk+00000000000047B4)
07/03/2014 07:12:19,spid126,Unknown,00007FFAEECD49D0 Module(sqldk+00000000000049D0)
07/03/2014 07:12:19,spid126,Unknown,00007FFAF1EDBC3F Module(sqlmin+00000000000FBC3F)
07/03/2014 07:12:19,spid126,Unknown,00007FFAF4D8D491 Module(sqlmin+0000000002FAD491)
07/03/2014 07:12:19,spid126,Unknown,00007FFAF4D81310 Module(sqlmin+0000000002FA1310)
07/03/2014 07:12:19,spid126,Unknown,00007FFAF4D80377 Module(sqlmin+0000000002FA0377)
07/03/2014 07:12:19,spid126,Unknown,00007FFAF4D5AE67 Module(sqlmin+0000000002F7AE67)
07/03/2014 07:12:19,spid126,Unknown,00007FFAF4D58614 Module(sqlmin+0000000002F78614)
07/03/2014 07:12:19,spid126,Unknown,00007FFAF4D7C29C Module(sqlmin+0000000002F9C29C)
07/03/2014 07:12:19,spid126,Unknown,00007FFAF4D7BF6F Module(sqlmin+0000000002F9BF6F)
07/03/2014 07:12:19,spid126,Unknown,00007FFAF4A68E85 Module(sqlmin+0000000002C88E85)
07/03/2014 07:12:19,spid126,Unknown,00007FFAF27B2D45 Module(sqlmin+00000000009D2D45)
07/03/2014 07:12:19,spid126,Unknown,* Short Stack Dump
07/03/2014 07:12:19,spid126,Unknown,* -------------------------------------------------------------------------------
07/03/2014 07:12:19,spid126,Unknown,* *******************************************************************************
07/03/2014 07:12:19,spid126,Unknown,* Rip: 00007FFAF27B2D45: 104089490904034A C033C300000001B8 000001B810408949 909090C3C033C300 9090909090909090 27A9058B4C909090
07/03/2014 07:12:19,spid126,Unknown,* R15: FFFFFFFFFFFFFFFF:
07/03/2014 07:12:19,spid126,Unknown,* R14: 00000000FC867F80: 004D005C003A0045 004C005100530053 004B00410042005C 005300440053005C 002E007400610074 0000006B00610062
07/03/2014 07:12:19,spid126,Unknown,* R13: 0000000013264300: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
07/03/2014 07:12:19,spid126,Unknown,* R12: 0000000000000019:
07/03/2014 07:12:19,spid126,Unknown,* R11: 00007FFAF595D490: 00007FFAF5944C90 00000006A74E0040 0000000000000000 0000000000000000 0000000000000000 0000000000000000
07/03/2014 07:12:19,spid126,Unknown,* R10: 0000000000000019:
07/03/2014 07:12:19,spid126,Unknown,* R9: 00007FFAF5925520: 0000000010CB0000 00000000000006F0 006C004700000001 006C00610062006F 004C00510053005C 003000310031005F
07/03/2014 07:12:19,spid126,Unknown,* R8: 000000002FBDE100: 0000000013264300 0000000010CC98F8 0000000193B02040 00007FFA004002B6 0000000000000000 0000000000000000
07/03/2014 07:12:19,spid126,Unknown,* Rdi: 000000000000000F:
07/03/2014 07:12:19,spid126,Unknown,* Rsi: 0000000000000000:
07/03/2014 07:12:19,spid126,Unknown,* Rbp: 000000002FBDE129: 0000000000000000 0000000000000000 FE00000000000000 FAFFFFFFFFFFFFFF 0F00000000000000 4000000000000000
07/03/2014 07:12:19,spid126,Unknown,* Rsp: 000000002FBDE078: 00007FFAF4A68E85 0000000000000000 000000002FBDE129 0000000000000000 00000000000006F0 00000000FC867F70
07/03/2014 07:12:19,spid126,Unknown,* Rbx: 00000001B2C72160: 0000000000000000 0000000000000000 00000017397D8170 000000000281C170 00007FFA00000001 00000006AA080298
07/03/2014 07:12:19,spid126,Unknown,* Rdx: 0000000010CB1AA0: FFFFFFFFFFFFFFFF 0053004C00510053 0065007600720065 00610042003A0072 00700075006B0063 0076006500440020
07/03/2014 07:12:19,spid126,Unknown,* Rcx: 00000002A4DEF4A0: 56790000000012BF 0002000000009BB5 0500050000F5D300 5A0000BE7E15A000 00000012BF5BB500 0000009BB5567A00
07/03/2014 07:12:19,spid126,Unknown,* Rax: 0000000000000000:
07/03/2014 07:12:19,spid126,Unknown,* EFlags: 0000000000010206:
07/03/2014 07:12:19,spid126,Unknown,* SegSs: 000000000000002B:
07/03/2014 07:12:19,spid126,Unknown,* SegGs: 000000000000002B:
07/03/2014 07:12:19,spid126,Unknown,* SegFs: 0000000000000053:
07/03/2014 07:12:19,spid126,Unknown,* SegEs: 000000000000002B:
07/03/2014 07:12:19,spid126,Unknown,* SegDs: 000000000000002B:
07/03/2014 07:12:19,spid126,Unknown,* SegCs: 0000000000000033:
07/03/2014 07:12:19,spid126,Unknown,* MxCsr: 0000000000001FA0:
07/03/2014 07:12:19,spid126,Unknown,* ContextFlags: 000000000010005F:
07/03/2014 07:12:19,spid126,Unknown,* P6Home: 00007FFAEEF45A40: 00007FFAEEE40ED0 00000000020B00F0 0000000C00000040 0000000000002000 0000000100030008 00007FFAEEF37540
07/03/2014 07:12:19,spid126,Unknown,* P5Home: 0000000000000001:
07/03/2014 07:12:19,spid126,Unknown,* P4Home: 00000000013A0000: 00000000013A0000 00000000013B0000 0000000000000008 0000000001390000 0000000000000000 0000000000000000
07/03/2014 07:12:19,spid126,Unknown,* P3Home: 00000001B2C72160: 0000000000000000 0000000000000000 00000017397D8170 000000000281C170 00007FFA00000001 00000006AA080298
07/03/2014 07:12:19,spid126,Unknown,* P2Home: 0000000000000001:
07/03/2014 07:12:19,spid126,Unknown,* P1Home: 0000000000FFFFFF: 0000000100000000 0000000101000000 0000000000000800 00000000FF000000 0000000000000000 0000000000000000
07/03/2014 07:12:19,spid126,Unknown,*
07/03/2014 07:12:19,spid126,Unknown,* dbghelp 0000000068670000 0000000068805FFF 00196000
07/03/2014 07:12:19,spid126,Unknown,* ssdebugps 00007FFAEC940000 00007FFAEC951FFF 00012000
07/03/2014 07:12:19,spid126,Unknown,* xplog70 00007FFAFB5D0000 00007FFAFB5D3FFF 00004000
07/03/2014 07:12:19,spid126,Unknown,* xplog70 00007FFAFAEF0000 00007FFAFAF00FFF 00011000
07/03/2014 07:12:19,spid126,Unknown,* DSROLE 00007FFAFBB40000 00007FFAFBB48FFF 00009000
07/03/2014 07:12:19,spid126,Unknown,* xpstar 00007FFAEAD20000 00007FFAEAD2CFFF 0000d000
07/03/2014 07:12:19,spid126,Unknown,* SQLSCM 00007FFAFB030000 00007FFAFB03EFFF 0000f000
07/03/2014 07:12:19,spid126,Unknown,* ODBC32 00007FFAE9B00000 00007FFAE9BBBFFF 000bc000
07/03/2014 07:12:19,spid126,Unknown,* xpstar 00007FFAE5700000 00007FFAE5768FFF 00069000
07/03/2014 07:12:19,spid126,Unknown,* xpsqlbot 00007FFAFB020000 00007FFAFB027FFF 00008000
07/03/2014 07:12:19,spid126,Unknown,* ncryptsslp 00007FFAEAFC0000 00007FFAEAFDAFFF 0001b000
07/03/2014 07:12:19,spid126,Unknown,* ESENT 00007FFAF9E90000 00007FFAFA140FFF 002b1000
07/03/2014 07:12:19,spid126,Unknown,* ualapi 00007FFAFA2A0000 00007FFAFA2B8FFF 00019000
07/03/2014 07:12:19,spid126,Unknown,* msxml3 00007FFAEE400000 00007FFAEE60FFFF 00210000
07/03/2014 07:12:19,spid126,Unknown,* wbemcomn 00007FFAF9A20000 00007FFAF9A9EFFF 0007f000
07/03/2014 07:12:19,spid126,Unknown,* wmiaprpl 00007FFAE90E0000 00007FFAE9103FFF 00024000
07/03/2014 07:12:19,spid126,Unknown,* fwpuclnt 00007FFAFB6A0000 00007FFAFB707FFF 00068000
07/03/2014 07:12:19,spid126,Unknown,* rasadhlp 00007FFAFA300000 00007FFAFA308FFF 00009000
07/03/2014 07:12:19,spid126,Unknown,* DSPARSE 00007FFAFA150000 00007FFAFA15AFFF 0000b000
07/03/2014 07:12:19,spid126,Unknown,* ntdsapi 00007FFAFBB90000 00007FFAFBBB7FFF 00028000
07/03/2014 07:12:19,spid126,Unknown,* mswsock 00007FFAFEDF0000 00007FFAFEE47FFF 00058000
07/03/2014 07:12:19,spid126,Unknown,* MSFTE 0000000049980000 0000000049D2DFFF 003ae000
07/03/2014 07:12:19,spid126,Unknown,* ftimport 0000000060000000 0000000060024FFF 00025000
07/03/2014 07:12:19,spid126,Unknown,* RsFxFt 00007FFAFB480000 00007FFAFB488FFF 00009000
07/03/2014 07:12:19,spid126,Unknown,* BatchParser 00007FFAEA600000 00007FFAEA627FFF 00028000
07/03/2014 07:12:19,spid126,Unknown,* iisutil 00007FFAF9E10000 00007FFAF9E59FFF 0004a000
07/03/2014 07:12:19,spid126,Unknown,* w3ctrs 00007FFAE9110000 00007FFAE911AFFF 0000b000
07/03/2014 07:12:19,spid126,Unknown,* usbperf 00007FFAE9120000 00007FFAE9127FFF 00008000
07/03/2014 07:12:19,spid126,Unknown,* SETUPAPI 00007FFB01F00000 00007FFB020D3FFF 001d4000
07/03/2014 07:12:19,spid126,Unknown,* UTILDLL 00007FFAE9130000 00007FFAE9146FFF 00017000
07/03/2014 07:12:19,spid126,Unknown,* WINSTA 00007FFAFF4B0000 00007FFAFF506FFF 00057000
07/03/2014 07:12:19,spid126,Unknown,* perfts 00007FFAE9150000 00007FFAE9158FFF 00009000
07/03/2014 07:12:19,spid126,Unknown,* WINNSI 00007FFAFB7D0000 00007FFAFB7D9FFF 0000a000
07/03/2014 07:12:19,spid126,Unknown,* IPHLPAPI 00007FFAFBAA0000 00007FFAFBAC8FFF 00029000
07/03/2014 07:12:19,spid126,Unknown,* Perfctrs 00007FFAE9160000 00007FFAE916FFFF 00010000
07/03/2014 07:12:19,spid126,Unknown,* tapiperf 00007FFAEA7B0000 00007FFAEA7B7FFF 00008000
07/03/2014 07:12:19,spid126,Unknown,* perf-MSSQL12.MSSQLSERVER-sqlagtctr 000000006A6D0000 000000006A6EBFFF 0001c000
07/03/2014 07:12:19,spid126,Unknown,* winspool 00007FFAECD70000 00007FFAECDEAFFF 0007b000
07/03/2014 07:12:19,spid126,Unknown,* perf-ReportServer-rsctr12.0.2000.8 00007FFAEA890000 00007FFAEA8A7FFF 00018000
07/03/2014 07:12:19,spid126,Unknown,* rasman 00007FFAFC080000 00007FFAFC0ADFFF 0002e000
07/03/2014 07:12:19,spid126,Unknown,* rasctrs 00007FFAEA8B0000 00007FFAEA8B8FFF 00009000
07/03/2014 07:12:19,spid126,Unknown,* perfproc 00007FFAEA8C0000 00007FFAEA8CEFFF 0000f000
07/03/2014 07:12:19,spid126,Unknown,* perfos 00007FFAEA650000 00007FFAEA65CFFF 0000d000
07/03/2014 07:12:19,spid126,Unknown,* BROWCLI 00007FFAEAD40000 00007FFAEAD51FFF 00012000
07/03/2014 07:12:19,spid126,Unknown,* perfnet 00007FFAEA660000 00007FFAEA669FFF 0000a000
07/03/2014 07:12:19,spid126,Unknown,* WMICLNT 00007FFAFBA70000 00007FFAFBA7DFFF 0000e000
07/03/2014 07:12:19,spid126,Unknown,* perfdisk 00007FFAEA8F0000 00007FFAEA8FDFFF 0000e000
07/03/2014 07:12:19,spid126,Unknown,* perf-MSSQLSERVER-sqlctr12.0.2000.8 00007FFAE0EE0000 00007FFAE0F32FFF 00053000
07/03/2014 07:12:19,spid126,Unknown,* ktmw32 00007FFAFB5F0000 00007FFAFB5FAFFF 0000b000
07/03/2014 07:12:19,spid126,Unknown,* MTXCLU 00007FFAEA670000 00007FFAEA6D3FFF 00064000
07/03/2014 07:12:19,spid126,Unknown,* MSDTCPRX 00007FFAEA6E0000 00007FFAEA7A7FFF 000c8000
07/03/2014 07:12:19,spid126,Unknown,* ATL 00007FFAFBAD0000 00007FFAFBAEAFFF 0001b000
07/03/2014 07:12:19,spid126,Unknown,* DNSAPI 00007FFAFEC00000 00007FFAFECA2FFF 000a3000
07/03/2014 07:12:19,spid126,Unknown,* msdtcuiu 00007FFAEA900000 00007FFAEA94BFFF 0004c000
07/03/2014 07:12:19,spid126,Unknown,* MOMConnectorPerformance 00007FFAFB330000 00007FFAFB339FFF 0000a000
07/03/2014 07:12:19,spid126,Unknown,* loadperf 00007FFAEE030000 00007FFAEE052FFF 00023000
07/03/2014 07:12:19,spid126,Unknown,* InterceptCounters 00007FFADF1E0000 00007FFADF274FFF 00095000
07/03/2014 07:12:19,spid126,Unknown,* HealthServicePerformance 00007FFAFB570000 00007FFAFB57BFFF 0000c000
07/03/2014 07:12:19,spid126,Unknown,* esentprf 00007FFAEA8D0000 00007FFAEA8E7FFF 00018000
07/03/2014 07:12:19,spid126,Unknown,* DTSPipelinePerf120 00007FFAEA950000 00007FFAEA95CFFF 0000d000
07/03/2014 07:12:19,spid126,Unknown,* ccmcore 000000006A120000 000000006A23CFFF 0011d000
07/03/2014 07:12:19,spid126,Unknown,* ccmperf 000000006A080000 000000006A097FFF 00018000
07/03/2014 07:12:19,spid126,Unknown,* FrameworkPerf 000000006A270000 000000006A276FFF 00007000
07/03/2014 07:12:19,spid126,Unknown,* bitsperf 00007FFAFB560000 00007FFAFB569FFF 0000a000
07/03/2014 07:12:19,spid126,Unknown,* MSVCR80 000000006AE10000 000000006AED8FFF 000c9000
07/03/2014 07:12:19,spid126,Unknown,* aspnet_perf 00007FFAEA960000 00007FFAEA96CFFF 0000d000
07/03/2014 07:12:19,spid126,Unknown,* aspnet_perf 00007FFAEA970000 00007FFAEA97CFFF 0000d000
07/03/2014 07:12:19,spid126,Unknown,* aspnet_counters 00007FFAEA990000 00007FFAEA997FFF 00008000
07/03/2014 07:12:19,spid126,Unknown,* WTSAPI32 00007FFAFD190000 00007FFAFD1A0FFF 00011000
07/03/2014 07:12:19,spid126,Unknown,* CorperfmonExt 00007FFAEA9A0000 00007FFAEA9C5FFF 00026000
07/03/2014 07:12:19,spid126,Unknown,* perfcounter 00007FFAEA9D0000 00007FFAEAA0CFFF 0003d000
07/03/2014 07:12:19,spid126,Unknown,* netfxperf 00007FFAEAB50000 00007FFAEAB5EFFF 0000f000
07/03/2014 07:12:19,spid126,Unknown,* clrjit 00007FFAEAA20000 00007FFAEAB4EFFF 0012f000
07/03/2014 07:12:19,spid126,Unknown,* SqlAccess 0000000026540000 00000000265B1FFF 00072000
07/03/2014 07:12:19,spid126,Unknown,* mscorlib.ni 00007FFAF7880000 00007FFAF8E0CFFF 0158d000
07/03/2014 07:12:19,spid126,Unknown,* MSVCR120_CLR0400 00007FFAF8E40000 00007FFAF8F15FFF 000d6000
07/03/2014 07:12:19,spid126,Unknown,* clr 00007FFAF8F20000 00007FFAF989BFFF 0097c000
07/03/2014 07:12:19,spid126,Unknown,* DPAPI 00007FFAFE2B0000 00007FFAFE2B8FFF 00009000
07/03/2014 07:12:19,spid126,Unknown,* SQLNCLIR11 000000006A8D0000 000000006A907FFF 00038000
07/03/2014 07:12:19,spid126,Unknown,* SHCORE 00007FFAFDC10000 00007FFAFDCAEFFF 0009f000
07/03/2014 07:12:19,spid126,Unknown,* SHELL32 00007FFAFFC00000 00007FFB01015FFF 01416000
07/03/2014 07:12:19,spid126,Unknown,* COMDLG32 00007FFAFFB60000 00007FFAFFBF9FFF 0009a000
07/03/2014 07:12:19,spid126,Unknown,* COMCTL32 00007FFAFF7C0000 00007FFAFF860FFF 000a1000
07/03/2014 07:12:19,spid126,Unknown,* sqlncli11 000000006A910000 000000006AC62FFF 00353000
07/03/2014 07:12:19,spid126,Unknown,* clbcatq 00007FFB01BC0000 00007FFB01C63FFF 000a4000
07/03/2014 07:12:19,spid126,Unknown,* kernel.appcore 00007FFAFE2F0000 00007FFAFE2F9FFF 0000a000
07/03/2014 07:12:19,spid126,Unknown,* security 00007FFAECBD0000 00007FFAECBD2FFF 00003000
07/03/2014 07:12:19,spid126,Unknown,* mscoreei 00007FFAF9B00000 00007FFAF9B9CFFF 0009d000
07/03/2014 07:12:19,spid126,Unknown,* MSCOREE 00007FFAF9CF0000 00007FFAF9D53FFF 00064000
07/03/2014 07:12:19,spid126,Unknown,* schannel 00007FFAFEA00000 00007FFAFEA6AFFF 0006b000
07/03/2014 07:12:19,spid126,Unknown,* kerberos 00007FFAFEE70000 00007FFAFEF5AFFF 000eb000
07/03/2014 07:12:19,spid126,Unknown,* msv1_0 00007FFAFED80000 00007FFAFEDE7FFF 00068000
07/03/2014 07:12:19,spid126,Unknown,* pcwum 00007FFAFE830000 00007FFAFE83DFFF 0000e000
07/03/2014 07:12:19,spid126,Unknown,* SHLWAPI 00007FFB012F0000 00007FFB01340FFF 00051000
07/03/2014 07:12:19,spid126,Unknown,* XmlLite 00007FFAFC180000 00007FFAFC1B7FFF 00038000
07/03/2014 07:12:19,spid126,Unknown,* dbghelp 000000006AC70000 000000006AE05FFF 00196000
07/03/2014 07:12:19,spid126,Unknown,* hkengine 00007FFAEB3B0000 00007FFAEB55EFFF 001af000
07/03/2014 07:12:19,spid126,Unknown,* hkcompile 00007FFAEB560000 00007FFAEB61DFFF 000be000
07/03/2014 07:12:19,spid126,Unknown,* hkruntime 00007FFAEB620000 00007FFAEB8D6FFF 002b7000
07/03/2014 07:12:19,spid126,Unknown,* VERSION 00007FFAFCE50000 00007FFAFCE59FFF 0000a000
07/03/2014 07:12:19,spid126,Unknown,* RESUTILS 00007FFAECA70000 00007FFAECAB8FFF 00049000
07/03/2014 07:12:19,spid126,Unknown,* cryptdll 00007FFAFEF60000 00007FFAFEF77FFF 00018000
07/03/2014 07:12:19,spid126,Unknown,* CLUSAPI 00007FFAECA00000 00007FFAECA6AFFF 0006b000
07/03/2014 07:12:19,spid126,Unknown,* ntmarta 00007FFAFCB90000 00007FFAFCBBFFFF 00030000
07/03/2014 07:12:19,spid126,Unknown,* gpapi 00007FFAFE7F0000 00007FFAFE812FFF 00023000
07/03/2014 07:12:19,spid126,Unknown,* NTASN1 00007FFAFF030000 00007FFAFF069FFF 0003a000
07/03/2014 07:12:19,spid126,Unknown,* ncrypt 00007FFAFF070000 00007FFAFF093FFF 00024000
07/03/2014 07:12:19,spid126,Unknown,* imagehlp 00007FFB01080000 00007FFB01094FFF 00015000
07/03/2014 07:12:19,spid126,Unknown,* bcrypt 00007FFAFF0A0000 00007FFAFF0C5FFF 00026000
07/03/2014 07:12:19,spid126,Unknown,* rsaenh 00007FFAFEAB0000 00007FFAFEAE4FFF 00035000
07/03/2014 07:12:19,spid126,Unknown,* CRYPTSP 00007FFAFEE50000 00007FFAFEE6DFFF 0001e000
07/03/2014 07:12:19,spid126,Unknown,* sqlevn70 00007FFAEE610000 00007FFAEE8BCFFF 002ad000
07/03/2014 07:12:19,spid126,Unknown,* cscapi 00007FFAF7800000 00007FFAF780FFFF 00010000
07/03/2014 07:12:19,spid126,Unknown,* instapi120 00007FFAF66D0000 00007FFAF66DEFFF 0000f000
07/03/2014 07:12:19,spid126,Unknown,* bcryptPrimitives 00007FFAFF3A0000 00007FFAFF3FFFFF 00060000
07/03/2014 07:12:19,spid126,Unknown,* CRYPTBASE 00007FFAFF400000 00007FFAFF409FFF 0000a000
07/03/2014 07:12:19,spid126,Unknown,* SAMCLI 00007FFAF9C30000 00007FFAF9C46FFF 00017000
07/03/2014 07:12:19,spid126,Unknown,* LOGONCLI 00007FFAFEBC0000 00007FFAFEBFCFFF 0003d000
07/03/2014 07:12:19,spid126,Unknown,* DEVOBJ 00007FFAFE4A0000 00007FFAFE4C5FFF 00026000
07/03/2014 07:12:19,spid126,Unknown,* cfgmgr32 00007FFAFF660000 00007FFAFF6A9FFF 0004a000
07/03/2014 07:12:19,spid126,Unknown,* SSPICLI 00007FFAFF370000 00007FFAFF39AFFF 0002b000
07/03/2014 07:12:19,spid126,Unknown,* WINMMBASE 00007FFAEEB20000 00007FFAEEB49FFF 0002a000
07/03/2014 07:12:19,spid126,Unknown,* profapi 00007FFAFF590000 00007FFAFF5A3FFF 00014000
07/03/2014 07:12:19,spid126,Unknown,* GDI32 00007FFB01A60000 00007FFB01BA3FFF 00144000
07/03/2014 07:12:19,spid126,Unknown,* combase 00007FFB010A0000 00007FFB01275FFF 001d6000
07/03/2014 07:12:19,spid126,Unknown,* NSI 00007FFB01060000 00007FFB01068FFF 00009000
07/03/2014 07:12:19,spid126,Unknown,* MSASN1 00007FFAFF640000 00007FFAFF651FFF 00012000
07/03/2014 07:12:19,spid126,Unknown,* WINMM 00007FFAEEB50000 00007FFAEEB6EFFF 0001f000
07/03/2014 07:12:19,spid126,Unknown,* WINTRUST 00007FFAFFA50000 00007FFAFFA9BFFF 0004c000
07/03/2014 07:12:19,spid126,Unknown,* AUTHZ 00007FFAFE870000 00007FFAFE8B7FFF 00048000
07/03/2014 07:12:19,spid126,Unknown,* USERENV 00007FFAFEBA0000 00007FFAFEBBDFFF 0001e000
07/03/2014 07:12:19,spid126,Unknown,* qds 00007FFAEEB70000 00007FFAEEBFDFFF 0008e000
07/03/2014 07:12:19,spid126,Unknown,* OLEAUT32 00007FFAFFAA0000 00007FFAFFB56FFF 000b7000
07/03/2014 07:12:19,spid126,Unknown,* ole32 00007FFB01C70000 00007FFB01DE7FFF 00178000
07/03/2014 07:12:19,spid126,Unknown,* USER32 00007FFB01490000 00007FFB01600FFF 00171000
07/03/2014 07:12:19,spid126,Unknown,* WINHTTP 00007FFAEEC00000 00007FFAEECC4FFF 000c5000
07/03/2014 07:12:19,spid126,Unknown,* WS2_32 00007FFB01800000 00007FFB01857FFF 00058000
07/03/2014 07:12:19,spid126,Unknown,* PSAPI 00007FFB01BB0000 00007FFB01BB6FFF 00007000
07/03/2014 07:12:19,spid126,Unknown,* Secur32 00007FFAF9AB0000 00007FFAF9ABAFFF 0000b000
07/03/2014 07:12:19,spid126,Unknown,* CRYPT32 00007FFAFF870000 00007FFAFFA46FFF 001d7000
07/03/2014 07:12:19,spid126,Unknown,* sechost 00007FFB01290000 00007FFB012E6FFF 00057000
07/03/2014 07:12:19,spid126,Unknown,* RPCRT4 00007FFB01350000 00007FFB01485FFF 00136000
07/03/2014 07:12:19,spid126,Unknown,* msvcrt 00007FFB01750000 00007FFB017F6FFF 000a7000
07/03/2014 07:12:19,spid126,Unknown,* wkscli 00007FFAFE290000 00007FFAFE2A5FFF 00016000
07/03/2014 07:12:19,spid126,Unknown,* srvcli 00007FFAFF0D0000 00007FFAFF0F4FFF 00025000
07/03/2014 07:12:19,spid126,Unknown,* netutils 00007FFAFE280000 00007FFAFE28BFFF 0000c000
07/03/2014 07:12:19,spid126,Unknown,* sqldk 00007FFAEECD0000 00007FFAEF198FFF 004c9000
07/03/2014 07:12:19,spid126,Unknown,* sqlTsEs 00007FFAEF1A0000 00007FFAEFA32FFF 00893000
07/03/2014 07:12:19,spid126,Unknown,* sqllang 00007FFAEFA40000 00007FFAF1CA6FFF 02267000
07/03/2014 07:12:19,spid126,Unknown,* sqlmin 00007FFAF1DE0000 00007FFAF5C7CFFF 03e9d000
07/03/2014 07:12:19,spid126,Unknown,* SQLOS 00007FFAF5C80000 00007FFAF5C86FFF 00007000
07/03/2014 07:12:19,spid126,Unknown,* MSVCP100 000000006AEE0000 000000006AF77FFF 00098000
07/03/2014 07:12:19,spid126,Unknown,* MSVCR100 000000006AFB0000 000000006B081FFF 000d2000
07/03/2014 07:12:19,spid126,Unknown,* ADVAPI32 00007FFB01DF0000 00007FFB01E94FFF 000a5000
07/03/2014 07:12:19,spid126,Unknown,* opends60 00007FFAF5C90000 00007FFAF5C98FFF 00009000
07/03/2014 07:12:19,spid126,Unknown,* pdh 00007FFAF5CA0000 00007FFAF5CECFFF 0004d000
07/03/2014 07:12:19,spid126,Unknown,* NETAPI32 00007FFAFBAF0000 00007FFAFBB04FFF 00015000
07/03/2014 07:12:19,spid126,Unknown,* KERNELBASE 00007FFAFF6B0000 00007FFAFF7BEFFF 0010f000
07/03/2014 07:12:19,spid126,Unknown,* KERNEL32 00007FFB020E0000 00007FFB02219FFF 0013a000
07/03/2014 07:12:19,spid126,Unknown,* ntdll 00007FFB02220000 00007FFB023C9FFF 001aa000
07/03/2014 07:12:19,spid126,Unknown,* sqlservr 00007FF6B48A0000 00007FF6B48FEFFF 0005f000
07/03/2014 07:12:19,spid126,Unknown,* MODULE BASE END SIZE
07/03/2014 07:12:19,spid126,Unknown,*
07/03/2014 07:12:19,spid126,Unknown,*
07/03/2014 07:12:19,spid126,Unknown,* EWIND<c/> NOUNLOAD<c/> COMPRESSION<c/> STATS = 10
07/03/2014 07:12:19,spid126,Unknown,* ' WITH NOFORMAT<c/> INIT<c/> NAME = N'SDStat-Full Database Backup'<c/> SKIP<c/> NOR
07/03/2014 07:12:19,spid126,Unknown,* BACKUP DATABASE [SDStat] TO DISK = N'E:\MSSQL\BAK\SDStat.bak
07/03/2014 07:12:19,spid126,Unknown,* Input Buffer 370 bytes -
07/03/2014 07:12:19,spid126,Unknown,* Access Violation occurred reading address 00007FFD9A7149C0
07/03/2014 07:12:19,spid126,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
07/03/2014 07:12:19,spid126,Unknown,* Exception Address = 00007FFAF27B2D45 Module(sqlmin+00000000009D2D45)
07/03/2014 07:12:19,spid126,Unknown,*
07/03/2014 07:12:19,spid126,Unknown,*
07/03/2014 07:12:19,spid126,Unknown,* Private server build.
07/03/2014 07:12:19,spid126,Unknown,* 07/03/14 07:12:19 spid 14420
07/03/2014 07:12:19,spid126,Unknown,* BEGIN STACK DUMP:
07/03/2014 07:12:19,spid126,Unknown,*
07/03/2014 07:12:19,spid126,Unknown,* *******************************************************************************
07/03/2014 07:12:19,spid126,Unknown,SqlDumpExceptionHandler: Process 14420 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
07/03/2014 07:12:19,spid126,Unknown,***Stack Dump being sent to H:\MSSQL12.MSSQLSERVER\MSSQL\LOG\SQLDump0418.txt
July 3, 2014 at 8:24 am
Attached the SQL Dump log that was created just now when i attempted to perform DB Backup. Its strange why SQL Dump would be created for a simple operation like a DB Backup.
July 3, 2014 at 9:01 am
Something that severe sounds like a major issue with the SQL Server installation. First I'd try putting on the CU. If that doesn't resolve the issue, I'd get in touch with Microsoft.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 15, 2014 at 2:23 pm
I'm running into this as well, will be trying CU3 just in case, but I don't see anything listed on the pages for CU1/2/3 that seem to match. Strange, as I have another 2014 instance on that box, same version and edition and everything but it works fine.
Edit: Ockham's Razor at work. Before applying CUs I restarted instance...problems gone. Not sure what was in play but its resolved now....hopefully stays that way...
October 15, 2014 at 11:55 pm
This was removed by the editor as SPAM
October 20, 2014 at 1:11 pm
FYI, backups failing again today with full stack dump any time one is invoked, by native tools or LiteSpeed.
We're already enmeshed in a never-ending ticket with MS Premier over a CDC issue that looks like a bug (don't get me started 🙂 ) so I'm not eager to start another with them now, but I may try CU3, and failing that, it might justify a reinstall as something looks completely goofed up:
SqlDumpExceptionHandler: Process 6332 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
October 20, 2014 at 1:17 pm
Mac1986 (7/3/2014)
My Database backup is not working in SQL 2014 RTM version. It works fine on SQL Server 2008 R2.All databases are in Simple recovery model. Not sure what might be the issue. I'm admin for SQL instance and on the box.
DECLARE @BackupFile1 varchar(max)SET @BackupFile1 = 'E:\MSSQL\Bak\DailyBackups\MSDB\MSDB1_' + REPLACE(REPLACE(REPLACE(CONVERT(varchar,GETDATE(), 112),'-',''),':',''),' ','') + '.BAK'
BACKUP DATABASE MSDB TO
DISK = @BackupFile1
WITH NOFORMAT, NOINIT, NAME = N'MSDB-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, COMPRESSION,MAXTRANSFERSIZE = 4194304, STATS = 10
Error:
Msg 3013, Level 16, State 1, Line 25
BACKUP DATABASE is terminating abnormally.
sounds like a memory issue, try lowering the max transfer size to around 1MB and see what results you get
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2014 at 1:26 pm
Perry Whittle (10/20/2014)
sounds like a memory issue, try lowering the max transfer size to around 1MB and see what results you get
Thanks for the idea! I tried 1MB and the minimum 64kb, and still got the same error.
December 9, 2014 at 9:01 am
Did you solve it? I am getting same error.
January 20, 2015 at 9:07 am
same error
January 21, 2015 at 3:57 pm
Run a DBCC CHECKDB on the database.
I've seen this happen when there is a corrupt hard drive sector in the middle of the database.
Also Stop the SQL server and try to copy the mdf and ldf to somewhere else.
I mean copy not rename - if it give an error you are in serious trouble.
Your only option is to rename the original files and restore a backup.
Antivirus programs and disk imaging or server backup utilities
can also lock out pages of the database file having the same effect.
January 22, 2015 at 5:39 pm
Perry Whittle (10/20/2014)
Mac1986 (7/3/2014)
My Database backup is not working in SQL 2014 RTM version. It works fine on SQL Server 2008 R2.All databases are in Simple recovery model. Not sure what might be the issue. I'm admin for SQL instance and on the box.
DECLARE @BackupFile1 varchar(max)SET @BackupFile1 = 'E:\MSSQL\Bak\DailyBackups\MSDB\MSDB1_' + REPLACE(REPLACE(REPLACE(CONVERT(varchar,GETDATE(), 112),'-',''),':',''),' ','') + '.BAK'
BACKUP DATABASE MSDB TO
DISK = @BackupFile1
WITH NOFORMAT, NOINIT, NAME = N'MSDB-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, COMPRESSION,MAXTRANSFERSIZE = 4194304, STATS = 10
Error:
Msg 3013, Level 16, State 1, Line 25
BACKUP DATABASE is terminating abnormally.
sounds like a memory issue, try lowering the max transfer size to around 1MB and see what results you get
I'd also try specifying a low buffer count. I believe it's buffer count * max transfer size that dictates how much RAM backups use. So you should tailor the buffer count to how much memory you can spare.
Viewing 15 posts - 1 through 15 (of 32 total)
You must be logged in to reply to this topic. Login to reply