Post reply

Backup Failed in SQL 2014

  • March 27, 2015 at 8:00 am

    #306170

    I tried to take Database full backup in SQL 2014 RTM (12.0.2000) but backup is failed with below error

    i am facing this issue for all databases in server and tried to take backup to all drives but getting same issue. Any suggestions would be appreciate.

    in Error-log i found below message...............

    2015-03-27 09:54:05.31 spid60 * SegSs: 000000000000002B:

    2015-03-27 09:54:05.31 spid60 * EFlags: 0000000000010206: 000076E9A0700000 0000FFFFFFFF0000 0000000000000000 0000000000000000 000000000FA00000 0000000000000000

    2015-03-27 09:54:05.31 spid60 * Rax: 00000000856D1AA8: 0053004C00510053 0065007600720065 00610042003A0072 00700075006B0063 0076006500440020 0000006500630069

    2015-03-27 09:54:05.31 spid60 * Rcx: 0000000000000019:

    2015-03-27 09:54:05.31 spid60 * Rdx: 00000000856D0010: 0000000000000031 0053004C00510053 0065007600720065 0065004D003A0072 00790072006F006D 006F007200420020

    2015-03-27 09:54:05.31 spid60 * Rbx: 00000080F0C26160: 0000000000000000 0000000000000000 00000080EE2B0170 00000080FF080298 0000000000000001 00000080FF080298

    2015-03-27 09:54:05.31 spid60 * Rsp: 00000000D537DE70: 0000000000000000 00000000D537DF19 0000000000000000 0000000000000958 0000008040C2DF90 0000008040C50F88

    2015-03-27 09:54:05.31 spid60 * Rbp: 00000000D537DF19: 0000000000000000 0000000000000000 FE00000000000000 FAFFFFFFFFFFFFFF 1100000000000000 4000000000000000

    2015-03-27 09:54:05.31 spid60 * Rsi: 0000000000000000:

    2015-03-27 09:54:05.31 spid60 * Rdi: 0000000000000011:

    2015-03-27 09:54:05.31 spid60 * R8: 00000000856D0000: 0000000000000000 0001DEE800000001 0000000000000031 0053004C00510053 0065007600720065 0065004D003A0072

    2015-03-27 09:54:05.31 spid60 * R9: 00000000D537DF19: 0000000000000000 0000000000000000 FE00000000000000 FAFFFFFFFFFFFFFF 1100000000000000 4000000000000000

    2015-03-27 09:54:05.31 spid60 * R10: 0000000000000000:

    2015-03-27 09:54:05.31 spid60 * R11: 000007FEE6BED490: 000007FEE6BD4C90 00000080F6560040 0000000000000000 0000000000000000 0000000000000000 0000000000000000

    2015-03-27 09:54:05.31 spid60 * R12: 0000000000000019:

    2015-03-27 09:54:05.31 spid60 * R13: 000000008A774392:

    2015-03-27 09:54:05.31 spid60 * R14: 0000008040C2DFA0: 0050005C003A0045 0062005F00410054 0075006B00630061 00610062002E0070 000000000000006B 0000000001000100

    2015-03-27 09:54:05.31 spid60 * R15: FFFFFFFFFFFFFFFF:

    2015-03-27 09:54:05.31 spid60 * Rip: 000007FEE5CF8CF7: 0FD2854528558B45 558D48000001718E 8B48FDD49FA3E8D7 57840FFF8548E77D 8548138B49000001 49A74DB60F1274D2

    2015-03-27 09:54:05.31 spid60 * *******************************************************************************

    2015-03-27 09:54:05.31 spid60 * -------------------------------------------------------------------------------

    2015-03-27 09:54:05.31 spid60 * Short Stack Dump

    2015-03-27 09:54:05.32 spid60 000007FEE5CF8CF7 Module(sqlmin+0000000002C88CF7)

    2015-03-27 09:54:05.32 spid60 000007FEE600BF6F Module(sqlmin+0000000002F9BF6F)

    2015-03-27 09:54:05.33 spid60 000007FEE600C29C Module(sqlmin+0000000002F9C29C)

    2015-03-27 09:54:05.33 spid60 000007FEE5FE8614 Module(sqlmin+0000000002F78614)

    2015-03-27 09:54:05.33 spid60 000007FEE5FEAE67 Module(sqlmin+0000000002F7AE67)

    2015-03-27 09:54:05.33 spid60 000007FEE6010377 Module(sqlmin+0000000002FA0377)

    2015-03-27 09:54:05.33 spid60 000007FEE6011310 Module(sqlmin+0000000002FA1310)

    2015-03-27 09:54:05.33 spid60 000007FEE601D491 Module(sqlmin+0000000002FAD491)

    2015-03-27 09:54:05.34 spid60 000007FEE316BC3F Module(sqlmin+00000000000FBC3F)

    2015-03-27 09:54:05.34 spid60 000007FEEA2749D0 Module(sqldk+00000000000049D0)

    2015-03-27 09:54:05.34 spid60 000007FEEA2747B4 Module(sqldk+00000000000047B4)

    2015-03-27 09:54:05.34 spid60 000007FEEA2745B6 Module(sqldk+00000000000045B6)

    2015-03-27 09:54:05.34 spid60 000007FEEA2936FF Module(sqldk+00000000000236FF)

    2015-03-27 09:54:05.34 spid60 000007FEEA2938F0 Module(sqldk+00000000000238F0)

    2015-03-27 09:54:05.34 spid60 000007FEEA293246 Module(sqldk+0000000000023246)

    2015-03-27 09:54:05.35 spid60 000007FEEA293558 Module(sqldk+0000000000023558)

    2015-03-27 09:54:05.36 spid60 0000000076B559ED Module(kernel32+00000000000159ED)

    2015-03-27 09:54:05.36 spid60 0000000076D8C541 Module(ntdll+000000000002C541)

    2015-03-27 09:54:05.37 spid60 Stack Signature for the dump is 0x0000000174F028BC

    2015-03-27 09:54:05.60 spid60 [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 |

    2015-03-27 09:54:07.12 spid60 External dump process return code 0x20000001.

    External dump process returned no errors.

    2015-03-27 09:54:07.12 Backup Error: 3041, Severity: 16, State: 1.

    2015-03-27 09:54:07.12 Backup BACKUP failed to complete the command BACKUP DATABASE SalesAdmin. Check the backup application log for detailed messages.

  • March 29, 2015 at 2:45 am

    #1787154

    Quick note, you need to post more information, this is not enough!

    😎

  • April 8, 2015 at 2:57 pm

    #1789707

    I got the same error for backup, did you fix it? How did you fix it?

    Thanks

  • April 9, 2015 at 4:14 am

    #1789800

    Just curious: Are you able to take the backup from Query Analyzer executing command like:

    BACKUP DATABASE <dbname> TO DISK = <specify_path>

    If getting any error please post it here.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • April 9, 2015 at 5:58 am

    #1789824

    check the log for further error details and post these back

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • April 10, 2015 at 1:23 am

    #1790084

    WMI got broken. That will cause the backup fail 🙂

  • April 15, 2015 at 1:10 pm

    #1791170

    currently it is fixed after i restart the SQL Service for 2-3 times.

    Thanks to everyone.

  • April 20, 2015 at 3:55 am

    #1791960

    Hi,

    I am getting same backup issue again and again...

    once i restart the SQL service then backup is running fine, after 2 or 3 days i am getting same error message. i created backup in Maintenance plans and i tried with sql script also getting same issue. i am using SQL 2014 (RTM). Complete error message given below.

    ============================================================================

    spid69 * wship6 000007FEFCEA0000 000007FEFCEA6FFF 00007000

    2015-04-20 04:51:34.91 spid69 * wshtcpip 000007FEFC8B0000 000007FEFC8B6FFF 00007000

    2015-04-20 04:51:34.91 spid69 * ntdsapi 000007FEFAC90000 000007FEFACB6FFF 00027000

    2015-04-20 04:51:34.91 spid69 * IPHLPAPI 000007FEFB730000 000007FEFB756FFF 00027000

    2015-04-20 04:51:34.91 spid69 * WINNSI 000007FEFB710000 000007FEFB71AFFF 0000b000

    2015-04-20 04:51:34.91 spid69 * rasadhlp 000007FEFADF0000 000007FEFADF7FFF 00008000

    2015-04-20 04:51:34.91 spid69 * fwpuclnt 000007FEFB440000 000007FEFB492FFF 00053000

    2015-04-20 04:51:34.91 spid69 * BROWCLI 000007FEE9930000 000007FEE9941FFF 00012000

    2015-04-20 04:51:34.91 spid69 * rasman 000007FEFB4A0000 000007FEFB4BBFFF 0001c000

    2015-04-20 04:51:34.91 spid69 * xpsqlbot 000007FEF3280000 000007FEF3287FFF 00008000

    2015-04-20 04:51:34.91 spid69 * xpstar 000007FEF30C0000 000007FEF3128FFF 00069000

    2015-04-20 04:51:34.91 spid69 * ODBC32 000007FEE61A0000 000007FEE6250FFF 000b1000

    2015-04-20 04:51:34.92 spid69 * SQLSCM 000007FEF34E0000 000007FEF34EEFFF 0000f000

    2015-04-20 04:51:34.92 spid69 * odbcint 00000000A52C0000 00000000A52F7FFF 00038000

    2015-04-20 04:51:34.92 spid69 * xpstar 000007FEF3270000 000007FEF327CFFF 0000d000

    2015-04-20 04:51:34.92 spid69 * msxml3 000007FEEE630000 000007FEEE803FFF 001d4000

    2015-04-20 04:51:34.92 spid69 * xplog70 000007FEEA710000 000007FEEA720FFF 00011000

    2015-04-20 04:51:34.92 spid69 * xplog70 000007FEE9880000 000007FEE9883FFF 00004000

    2015-04-20 04:51:34.92 spid69 * System.ni 000007FEF7650000 000007FEF830AFFF 00cbb000

    2015-04-20 04:51:34.92 spid69 * System.Data 000007FEEC090000 000007FEEC3ADFFF 0031e000

    2015-04-20 04:51:34.92 spid69 * System.Transactions 000007FEF1EC0000 000007FEF1F08FFF 00049000

    2015-04-20 04:51:34.92 spid69 * System.Security.ni 000007FEF2A20000 000007FEF2B0CFFF 000ed000

    2015-04-20 04:51:34.92 spid69 * System.Xml.ni 000007FEF1F10000 000007FEF28D1FFF 009c2000

    2015-04-20 04:51:34.92 spid69 * System.Configuration.ni 000007FEEF5C0000 000007FEEF6F8FFF 00139000

    2015-04-20 04:51:34.92 spid69 * perfproc 000007FEFADD0000 000007FEFADDDFFF 0000e000

    2015-04-20 04:51:34.92 spid69 * apphelp 000007FEFD510000 000007FEFD566FFF 00057000

    2015-04-20 04:51:34.92 spid69 * dbghelp 000000007CAD0000 000000007CC65FFF 00196000

    2015-04-20 04:51:34.92 spid69 *

    2015-04-20 04:51:34.92 spid69 * P1Home: 00000000D86EE220: 00000000C0000005 0000000000000000 000007FEDB552D45 0000000000000002 0000000000000000 000007FEDEC6B160

    2015-04-20 04:51:34.92 spid69 * P2Home: 00000000D86EDD30: 00000000D86EE220 00000000D86EDD30 0000007400000000 000007FE00000000 0000000078D9CB40 000007FE00000001

    2015-04-20 04:51:34.92 spid69 * P3Home: 0000007400000000:

    2015-04-20 04:51:34.92 spid69 * P4Home: 000007FE00000000:

    2015-04-20 04:51:34.92 spid69 * P5Home: 0000000078D9CB40: 0000000000000000 0000000000000000 0000000003423D20 0000000078D9CBE0 00000074C2000000 0000000000000000

    2015-04-20 04:51:34.92 spid69 * P6Home: 000007FE00000001:

    2015-04-20 04:51:34.92 spid69 * ContextFlags: 000000000010001F: 0000010000001400 0000340000000200 000001000000D400 0000000000000000 0000000000000000 0000020000000000

    2015-04-20 04:51:34.92 spid69 * MxCsr: 0000000000001FA0:

    2015-04-20 04:51:34.92 spid69 * SegCs: 0000000000000033:

    2015-04-20 04:51:34.92 spid69 * SegDs: 000000000000002B:

    2015-04-20 04:51:34.92 spid69 * SegEs: 000000000000002B:

    2015-04-20 04:51:34.92 spid69 * SegFs: 0000000000000053:

    2015-04-20 04:51:34.92 spid69 * SegGs: 000000000000002B:

    2015-04-20 04:51:34.92 spid69 * SegSs: 000000000000002B:

    2015-04-20 04:51:34.92 spid69 * EFlags: 0000000000010212: 000000000000FFFF 0000000000000000 0FA0000000000000 0000000000000000 0080000000000000 0001000000010000

    2015-04-20 04:51:34.92 spid69 * Rax: 0000000000000000:

    2015-04-20 04:51:34.92 spid69 * Rcx: 00000000005A5C40: 4D545FA89792E114 1ED9A321EA2BCD19 A88130C3DF31A1FC A081041F1D550306 81A09A81309D8130 746848869481A097

    2015-04-20 04:51:34.92 spid69 * Rdx: 0000000078D11AA0: FFFFFFFFFFFFFFFF 0053004C00510053 0065007600720065 00610042003A0072 00700075006B0063 0076006500440020

    2015-04-20 04:51:34.92 spid69 * Rbx: 0000007510614160: 0000000000000000 0000000000000000 000000752FEB2170 0000007537E08298 000007FE00000001 0000007537E08298

    2015-04-20 04:51:34.92 spid69 * Rsp: 00000000D86EE2E8: 000007FEDD808E85 0000000000000000 00000000D86EE399 0000000000000000 0000000000000958 00000074C2026640

    2015-04-20 04:51:34.92 spid69 * Rbp: 00000000D86EE399: 0000000000000000 0000000000000000 FE00000000000000 FAFFFFFFFFFFFFFF 1500000000000000 4000000000000000

    2015-04-20 04:51:34.92 spid69 * Rsi: 0000000000000000:

    2015-04-20 04:51:34.92 spid69 * Rdi: 0000000000000015:

    2015-04-20 04:51:34.92 spid69 * R8: 00000000D86EE370: 0000000078D2E90B 0000000078D298F8 00000074C203A040 000007FE004002B6 0000000000000000 0000000000000000

    2015-04-20 04:51:34.92 spid69 * R9: 000007FEDE6C5520: 0000000078D10000 0000000000000958 006C004700000001 006C00610062006F 004C00510053005C 003000310031005F

    2015-04-20 04:51:34.92 spid69 * R10: 0000000000000019:

    2015-04-20 04:51:34.92 spid69 * R11: 000007FEDE6FD490: 000007FEDE6E4C90 000000752E560040 0000000000000000 0000000000000000 0000000000000000 0000000000000000

    2015-04-20 04:51:34.92 spid69 * R12: 0000000000000019:

    2015-04-20 04:51:34.92 spid69 * R13: 0000000078D2E90B: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000

    2015-04-20 04:51:34.92 spid69 * R14: 00000074C2026650: 0044005C003A0044 0042005F0079006C 0075006B00630061 0052005C00730070 0072006F00700065 0072006500530074

    2015-04-20 04:51:34.92 spid69 * R15: FFFFFFFFFFFFFFFF:

    2015-04-20 04:51:34.92 spid69 * Rip: 000007FEDB552D45: 104089490904034A C033C300000001B8 000001B810408949 909090C3C033C300 9090909090909090 27A9058B4C909090

    2015-04-20 04:51:34.92 spid69 * *******************************************************************************

    2015-04-20 04:51:34.92 spid69 * -------------------------------------------------------------------------------

    2015-04-20 04:51:34.92 spid69 * Short Stack Dump

    2015-04-20 04:51:34.93 spid69 000007FEDB552D45 Module(sqlmin+00000000009D2D45)

    2015-04-20 04:51:34.93 spid69 000007FEDD808E85 Module(sqlmin+0000000002C88E85)

    2015-04-20 04:51:34.93 spid69 000007FEDDB1BF6F Module(sqlmin+0000000002F9BF6F)

    2015-04-20 04:51:34.93 spid69 000007FEDDB1C29C Module(sqlmin+0000000002F9C29C)

    2015-04-20 04:51:34.93 spid69 000007FEDDAF8614 Module(sqlmin+0000000002F78614)

    2015-04-20 04:51:34.93 spid69 000007FEDDAFAE67 Module(sqlmin+0000000002F7AE67)

    2015-04-20 04:51:34.94 spid69 000007FEDDB20377 Module(sqlmin+0000000002FA0377)

    2015-04-20 04:51:34.94 spid69 000007FEDDB21310 Module(sqlmin+0000000002FA1310)

    2015-04-20 04:51:34.94 spid69 000007FEDDB2D491 Module(sqlmin+0000000002FAD491)

    2015-04-20 04:51:34.95 spid69 000007FEDAC7BC3F Module(sqlmin+00000000000FBC3F)

    2015-04-20 04:51:34.95 spid69 000007FEF61C49D0 Module(sqldk+00000000000049D0)

    2015-04-20 04:51:34.95 spid69 000007FEF61C47B4 Module(sqldk+00000000000047B4)

    2015-04-20 04:51:34.95 spid69 000007FEF61C45B6 Module(sqldk+00000000000045B6)

    2015-04-20 04:51:34.95 spid69 000007FEF61E36FF Module(sqldk+00000000000236FF)

    2015-04-20 04:51:34.95 spid69 000007FEF61E38F0 Module(sqldk+00000000000238F0)

    2015-04-20 04:51:34.95 spid69 000007FEF61E3246 Module(sqldk+0000000000023246)

    2015-04-20 04:51:34.96 spid69 000007FEF61E3558 Module(sqldk+0000000000023558)

    2015-04-20 04:51:34.97 spid69 00000000777F59ED Module(kernel32+00000000000159ED)

    2015-04-20 04:51:34.97 spid69 000000007792C541 Module(ntdll+000000000002C541)

    2015-04-20 04:51:34.97 spid69 Stack Signature for the dump is 0x000000003A4041F2

    2015-04-20 04:51:35.19 spid69 [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 |

    2015-04-20 04:51:36.81 spid69 External dump process return code 0x20000001.

    External dump process returned no errors.

    2015-04-20 04:51:36.82 Backup Error: 3041, Severity: 16, State: 1.

    2015-04-20 04:51:36.82 Backup BACKUP failed to complete the command BACKUP DATABASE ReportServerTempDB. Check the backup application log for detailed messages.

    2015-04-20 04:51:36.85 spid69 ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\LOG\SQLDump1162.txt

    2015-04-20 04:51:36.85 spid69 SqlDumpExceptionHandler: Process 12408 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

    2015-04-20 04:51:36.85 spid69 * *******************************************************************************

    2015-04-20 04:51:36.85 spid69 *

    2015-04-20 04:51:36.85 spid69 * BEGIN STACK DUMP:

    2015-04-20 04:51:36.85 spid69 * 04/20/15 04:51:36 spid 12408

    2015-04-20 04:51:36.85 spid69 * Private server build.

    2015-04-20 04:51:36.85 spid69 *

    2015-04-20 04:51:36.85 spid69 *

    2015-04-20 04:51:36.85 spid69 * Exception Address = 000007FEDB552D45 Module(sqlmin+00000000009D2D45)

    2015-04-20 04:51:36.85 spid69 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

    2015-04-20 04:51:36.85 spid69 * Access Violation occurred reading address 000007FEDEC6B160

    2015-04-20 04:51:36.85 spid69 * Input Buffer 448 bytes -

    2015-04-20 04:51:36.85 spid69 * BACKUP DATABASE [Support] TO DISK = N'D:\Dly_Backups\Support

    2015-04-20 04:51:36.85 spid69 * _backup_2015_04_20_045121_7184311.bak' WITH NOFORMAT, NOINIT, NAME = N'

    2015-04-20 04:51:36.85 spid69 * Support_backup_2015_04_20_045121_7184311', SKIP, REWIND, NOUNLOAD, STAT

    2015-04-20 04:51:36.85 spid69 * S = 10

    2015-04-20 04:51:36.85 spid69 *

    2015-04-20 04:51:36.85 spid69 *

    2015-04-20 04:51:36.85 spid69 * MODULE BASE END SIZE

    2015-04-20 04:51:36.85 spid69 * sqlservr 00000000FFD70000 00000000FFDCEFFF 0005f000

    2015-04-20 04:51:36.85 spid69 * ntdll 0000000077900000 0000000077AA8FFF 001a9000

    2015-04-20 04:51:36.85 spid69 * kernel32 00000000777E0000 00000000778FEFFF 0011f000

    2015-04-20 04:51:36.85 spid69 * KERNELBASE 000007FEFDA60000 000007FEFDACBFFF 0006c000

    2015-04-20 04:51:36.85 spid69 * NETAPI32 000007FEFB190000 000007FEFB1A5FFF 00016000

    2015-04-20 04:51:36.85 spid69 * netutils 000007FEFCB40000 000007FEFCB4BFFF 0000c000

    2015-04-20 04:51:36.85 spid69 * msvcrt 000007FEFDEE0000 000007FEFDF7EFFF 0009f000

    2015-04-20 04:51:36.85 spid69 * srvcli 000007FEFD280000 000007FEFD2A2FFF 00023000

    2015-04-20 04:51:36.85 spid69 * RPCRT4 000007FEFE270000 000007FEFE39CFFF 0012d000

    2015-04-20 04:51:36.85 spid69 * wkscli 000007FEFB170000 000007FEFB184FFF 00015000

    2015-04-20 04:51:36.85 spid69 * pdh 000007FEF7160000 000007FEF71ADFFF 0004e000

    2015-04-20 04:51:36.85 spid69 * ADVAPI32 000007FEFFB30000 000007FEFFC0AFFF 000db000

    2015-04-20 04:51:36.85 spid69 * sechost 000007FEFF740000 000007FEFF75EFFF 0001f000

    2015-04-20 04:51:36.85 spid69 * opends60 000007FEFADA0000 000007FEFADA8FFF 00009000

    2015-04-20 04:51:36.85 spid69 * MSVCR100 0000000074570000 0000000074641FFF 000d2000

    2015-04-20 04:51:36.85 spid69 * MSVCP100 00000000744A0000 0000000074537FFF 00098000

    2015-04-20 04:51:36.85 spid69 * SQLOS 000007FEFAD90000 000007FEFAD96FFF 00007000

    2015-04-20 04:51:36.85 spid69 * sqlmin 000007FEDAB80000 000007FEDEA1CFFF 03e9d000

    2015-04-20 04:51:36.85 spid69 * CRYPT32 000007FEFD740000 000007FEFD8ABFFF 0016c000

    2015-04-20 04:51:36.85 spid69 * MSASN1 000007FEFD720000 000007FEFD72EFFF 0000f000

    2015-04-20 04:51:36.85 spid69 * Secur32 000007FEFD4A0000 000007FEFD4AAFFF 0000b000

    2015-04-20 04:51:36.85 spid69 * SSPICLI 000007FEFD4E0000 000007FEFD504FFF 00025000

    2015-04-20 04:51:36.85 spid69 * PSAPI 0000000077AD0000 0000000077AD6FFF 00007000

    2015-04-20 04:51:36.85 spid69 * WS2_32 000007FEFF4E0000 000007FEFF52CFFF 0004d000

    2015-04-20 04:51:36.85 spid69 * NSI 000007FEFE070000 000007FEFE077FFF 00008000

    2015-04-20 04:51:36.85 spid69 * WINHTTP 000007FEF31F0000 000007FEF3260FFF 00071000

    2015-04-20 04:51:36.85 spid69 * webio 000007FEF3180000 000007FEF31E3FFF 00064000

    2015-04-20 04:51:36.85 spid69 * USER32 00000000776E0000 00000000777D9FFF 000fa000

    2015-04-20 04:51:36.85 spid69 * GDI32 000007FEFE200000 000007FEFE266FFF 00067000

    2015-04-20 04:51:36.85 spid69 * LPK 000007FEFE420000 000007FEFE42DFFF 0000e000

    2015-04-20 04:51:36.85 spid69 * USP10 000007FEFDF80000 000007FEFE048FFF 000c9000

    2015-04-20 04:51:36.85 spid69 * ole32 000007FEFF530000 000007FEFF732FFF 00203000

    2015-04-20 04:51:36.85 spid69 * OLEAUT32 000007FEFE120000 000007FEFE1F6FFF 000d7000

    2015-04-20 04:51:36.85 spid69 * sqlTsEs 000007FEF6690000 000007FEF6F22FFF 00893000

    2015-04-20 04:51:36.85 spid69 * sqldk 000007FEF61C0000 000007FEF6688FFF 004c9000

    2015-04-20 04:51:36.85 spid69 * WINMM 000007FEF1A00000 000007FEF1A3AFFF 0003b000

    2015-04-20 04:51:36.85 spid69 * qds 000007FEF6130000 000007FEF61BDFFF 0008e000

    2015-04-20 04:51:36.85 spid69 * sqllang 000007FEF3EC0000 000007FEF6126FFF 02267000

    2015-04-20 04:51:36.85 spid69 * USERENV 000007FEFD970000 000007FEFD98DFFF 0001e000

    2015-04-20 04:51:36.85 spid69 * profapi 000007FEFD710000 000007FEFD71EFFF 0000f000

    2015-04-20 04:51:36.85 spid69 * LOGONCLI 000007FEFCD00000 000007FEFCD2FFFF 00030000

    2015-04-20 04:51:36.85 spid69 * SAMCLI 000007FEFA980000 000007FEFA993FFF 00014000

    2015-04-20 04:51:36.85 spid69 * AUTHZ 000007FEFD0E0000 000007FEFD10EFFF 0002f000

    2015-04-20 04:51:36.85 spid69 * WINTRUST 000007FEFD990000 000007FEFD9C9FFF 0003a000

    2015-04-20 04:51:36.85 spid69 * IMM32 000007FEFE540000 000007FEFE56DFFF 0002e000

    2015-04-20 04:51:36.85 spid69 * MSCTF 000007FEFE430000 000007FEFE538FFF 00109000

    2015-04-20 04:51:36.85 spid69 * CRYPTBASE 000007FEFD570000 000007FEFD57EFFF 0000f000

    2015-04-20 04:51:36.85 spid69 * instapi120 000007FEF71B0000 000007FEF71BEFFF 0000f000

    2015-04-20 04:51:36.85 spid69 * cscapi 000007FEEF460000 000007FEEF46EFFF 0000f000

    2015-04-20 04:51:36.85 spid69 * sqlevn70 000007FEF3C10000 000007FEF3EBCFFF 002ad000

    2015-04-20 04:51:36.85 spid69 * CRYPTSP 000007FEFCF10000 000007FEFCF26FFF 00017000

    2015-04-20 04:51:36.85 spid69 * rsaenh 000007FEFCC10000 000007FEFCC56FFF 00047000

    2015-04-20 04:51:36.85 spid69 * imagehlp 000007FEFE050000 000007FEFE068FFF 00019000

    2015-04-20 04:51:36.85 spid69 * ncrypt 000007FEFD090000 000007FEFD0DCFFF 0004d000

    2015-04-20 04:51:36.85 spid69 * bcrypt 000007FEFD060000 000007FEFD081FFF 00022000

    2015-04-20 04:51:36.85 spid69 * bcryptprimitives 000007FEFCB50000 000007FEFCB9BFFF 0004c000

    2015-04-20 04:51:36.85 spid69 * GPAPI 000007FEFC9B0000 000007FEFC9CAFFF 0001b000

    2015-04-20 04:51:36.85 spid69 * cryptnet 000007FEFA7A0000 000007FEFA7C6FFF 00027000

    2015-04-20 04:51:36.85 spid69 * WLDAP32 000007FEFDAD0000 000007FEFDB21FFF 00052000

    2015-04-20 04:51:36.85 spid69 * SHLWAPI 000007FEFFAB0000 000007FEFFB20FFF 00071000

    2015-04-20 04:51:36.85 spid69 * ntmarta 000007FEFC7B0000 000007FEFC7DCFFF 0002d000

    2015-04-20 04:51:36.85 spid69 * CLUSAPI 000007FEEDBE0000 000007FEEDC2FFFF 00050000

    2015-04-20 04:51:36.85 spid69 * cryptdll 000007FEFD190000 000007FEFD1A3FFF 00014000

    2015-04-20 04:51:36.85 spid69 * RESUTILS 000007FEEDBC0000 000007FEEDBD8FFF 00019000

    2015-04-20 04:51:36.85 spid69 * VERSION 000007FEFC7E0000 000007FEFC7EBFFF 0000c000

    2015-04-20 04:51:36.85 spid69 * hkruntime 000007FEF3950000 000007FEF3C06FFF 002b7000

    2015-04-20 04:51:36.85 spid69 * hkcompile 000007FEF3890000 000007FEF394DFFF 000be000

    2015-04-20 04:51:36.85 spid69 * XmlLite 000007FEFB910000 000007FEFB944FFF 00035000

    2015-04-20 04:51:36.85 spid69 * hkengine 000007FEF36E0000 000007FEF388EFFF 001af000

    2015-04-20 04:51:36.85 spid69 * dbghelp 000000007A770000 000000007A905FFF 00196000

    2015-04-20 04:51:36.85 spid69 * pcwum 000007FEFC970000 000007FEFC97CFFF 0000d000

    2015-04-20 04:51:36.85 spid69 * credssp 000007FEFCB00000 000007FEFCB09FFF 0000a000

    2015-04-20 04:51:36.85 spid69 * msv1_0 000007FEFCE40000 000007FEFCE91FFF 00052000

    2015-04-20 04:51:36.85 spid69 * kerberos 000007FEFCF30000 000007FEFCFE7FFF 000b8000

    2015-04-20 04:51:36.85 spid69 * schannel 000007FEFCCA0000 000007FEFCCF6FFF 00057000

    2015-04-20 04:51:36.85 spid69 * MSCOREE 000007FEFA400000 000007FEFA46EFFF 0006f000

    2015-04-20 04:51:36.85 spid69 * mscoreei 000007FEFA360000 000007FEFA3F6FFF 00097000

    2015-04-20 04:51:36.85 spid69 * security 0000000079DD0000 0000000079DD2FFF 00003000

    2015-04-20 04:51:36.85 spid69 * CLBCatQ 000007FEFE080000 000007FEFE118FFF 00099000

    2015-04-20 04:51:36.85 spid69 * sqlncli11 00000000C17F0000 00000000C1B42FFF 00353000

    2015-04-20 04:51:36.85 spid69 * COMCTL32 000007FEFA4A0000 000007FEFA53FFFF 000a0000

    2015-04-20 04:51:36.85 spid69 * COMDLG32 000007FEFF760000 000007FEFF7F6FFF 00097000

    2015-04-20 04:51:36.85 spid69 * SHELL32 000007FEFE570000 000007FEFF2F7FFF 00d88000

    2015-04-20 04:51:36.85 spid69 * SQLNCLIR11 000000007A110000 000000007A147FFF 00038000

    2015-04-20 04:51:36.85 spid69 * clr 000007FEF99F0000 000007FEFA35AFFF 0096b000

    2015-04-20 04:51:36.85 spid69 * MSVCR110_CLR0400 000007FEF9910000 000007FEF99E1FFF 000d2000

    2015-04-20 04:51:36.85 spid69 * mscorlib.ni 000007FEF8310000 000007FEF9909FFF 015fa000

    2015-04-20 04:51:36.85 spid69 * SqlAccess 000000007D9A0000 000000007DA11FFF 00072000

    2015-04-20 04:51:36.85 spid69 * clrjit 000007FEEEAD0000 000007FEEEC00FFF 00131000

    2015-04-20 04:51:36.85 spid69 * BatchParser 000007FEF3680000 000007FEF36A7FFF 00028000

    2015-04-20 04:51:36.85 spid69 * nlssorting 000007FEF7540000 000007FEF7555FFF 00016000

    2015-04-20 04:51:36.85 spid69 * ftimport 000000007B560000 000000007B584FFF 00025000

    2015-04-20 04:51:36.85 spid69 * MSFTE 00000000CA7D0000 00000000CAB7DFFF 003ae000

    2015-04-20 04:51:36.85 spid69 * perfcounter 000007FEF3640000 000007FEF367BFFF 0003c000

    2015-04-20 04:51:36.86 spid69 * aspnet_counters 000007FEFADC0000 000007FEFADC7FFF 00008000

    2015-04-20 04:51:36.86 spid69 * aspnet_perf 000007FEFAD80000 000007FEFAD8CFFF 0000d000

    2015-04-20 04:51:36.86 spid69 * MSVCR120_CLR0400 000007FEF33B0000 000007FEF3485FFF 000d6000

    2015-04-20 04:51:36.86 spid69 * aspnet_perf 000007FEFAD70000 000007FEFAD7CFFF 0000d000

    2015-04-20 04:51:36.86 spid69 * MSVCR80 00000000A4010000 00000000A40D8FFF 000c9000

    2015-04-20 04:51:36.86 spid69 * DNSAPI 000007FEFCD30000 000007FEFCD8AFFF 0005b000

    2015-04-20 04:51:36.86 spid69 * CFGMGR32 000007FEFD9E0000 000007FEFDA15FFF 00036000

    2015-04-20 04:51:36.86 spid69 * mswsock 000007FEFCEB0000 000007FEFCF04FFF 00055000

    2015-04-20 04:51:36.86 spid69 * wship6 000007FEFCEA0000 000007FEFCEA6FFF 00007000

    2015-04-20 04:51:36.86 spid69 * wshtcpip 000007FEFC8B0000 000007FEFC8B6FFF 00007000

    2015-04-20 04:51:36.86 spid69 * ntdsapi 000007FEFAC90000 000007FEFACB6FFF 00027000

    2015-04-20 04:51:36.86 spid69 * IPHLPAPI 000007FEFB730000 000007FEFB756FFF 00027000

    2015-04-20 04:51:36.86 spid69 * WINNSI 000007FEFB710000 000007FEFB71AFFF 0000b000

    2015-04-20 04:51:36.86 spid69 * rasadhlp 000007FEFADF0000 000007FEFADF7FFF 00008000

    2015-04-20 04:51:36.86 spid69 * fwpuclnt 000007FEFB440000 000007FEFB492FFF 00053000

    2015-04-20 04:51:36.86 spid69 * BROWCLI 000007FEE9930000 000007FEE9941FFF 00012000

    2015-04-20 04:51:36.86 spid69 * rasman 000007FEFB4A0000 000007FEFB4BBFFF 0001c000

    2015-04-20 04:51:36.86 spid69 * xpsqlbot 000007FEF3280000 000007FEF3287FFF 00008000

    2015-04-20 04:51:36.86 spid69 * xpstar 000007FEF30C0000 000007FEF3128FFF 00069000

    2015-04-20 04:51:36.86 spid69 * ODBC32 000007FEE61A0000 000007FEE6250FFF 000b1000

    2015-04-20 04:51:36.86 spid69 * SQLSCM 000007FEF34E0000 000007FEF34EEFFF 0000f000

    2015-04-20 04:51:36.86 spid69 * odbcint 00000000A52C0000 00000000A52F7FFF 00038000

    2015-04-20 04:51:36.86 spid69 * xpstar 000007FEF3270000 000007FEF327CFFF 0000d000

    2015-04-20 04:51:36.86 spid69 * msxml3 000007FEEE630000 000007FEEE803FFF 001d4000

    2015-04-20 04:51:36.86 spid69 * xplog70 000007FEEA710000 000007FEEA720FFF 00011000

    2015-04-20 04:51:36.86 spid69 * xplog70 000007FEE9880000 000007FEE9883FFF 00004000

    2015-04-20 04:51:36.86 spid69 * System.ni 000007FEF7650000 000007FEF830AFFF 00cbb000

    2015-04-20 04:51:36.86 spid69 * System.Data 000007FEEC090000 000007FEEC3ADFFF 0031e000

    2015-04-20 04:51:36.86 spid69 * System.Transactions 000007FEF1EC0000 000007FEF1F08FFF 00049000

    2015-04-20 04:51:36.86 spid69 * System.Security.ni 000007FEF2A20000 000007FEF2B0CFFF 000ed000

    2015-04-20 04:51:36.86 spid69 * System.Xml.ni 000007FEF1F10000 000007FEF28D1FFF 009c2000

    2015-04-20 04:51:36.86 spid69 * System.Configuration.ni 000007FEEF5C0000 000007FEEF6F8FFF 00139000

    2015-04-20 04:51:36.86 spid69 * perfproc 000007FEFADD0000 000007FEFADDDFFF 0000e000

    2015-04-20 04:51:36.86 spid69 * apphelp 000007FEFD510000 000007FEFD566FFF 00057000

    2015-04-20 04:51:36.86 spid69 * dbghelp 000000007CAD0000 000000007CC65FFF 00196000

    2015-04-20 04:51:36.86 spid69 *

    2015-04-20 04:51:36.86 spid69 * P1Home: 00000000D86EE220: 00000000C0000005 0000000000000000 000007FEDB552D45 0000000000000002 0000000000000000 000007FEDEC6B160

    2015-04-20 04:51:36.86 spid69 * P2Home: 00000000D86EDD30: 00000000D86EE220 00000000D86EDD30 0000007400000000 000007FE00000000 0000000078D9CB40 000007FE00000001

    2015-04-20 04:51:36.86 spid69 * P3Home: 0000007400000000:

    2015-04-20 04:51:36.86 spid69 * P4Home: 000007FE00000000:

    2015-04-20 04:51:36.86 spid69 * P5Home: 0000000078D9CB40: 0000000000000000 0000000000000000 0000000003423D20 0000000078D9CBE0 00000074C2000000 0000000000000000

    2015-04-20 04:51:36.86 spid69 * P6Home: 000007FE00000001:

    2015-04-20 04:51:36.86 spid69 * ContextFlags: 000000000010001F: 0000010000001400 0000340000000200 000001000000D400 0000000000000000 0000000000000000 0000020000000000

    2015-04-20 04:51:36.86 spid69 * MxCsr: 0000000000001FA0:

    2015-04-20 04:51:36.86 spid69 * SegCs: 0000000000000033:

    2015-04-20 04:51:36.86 spid69 * SegDs: 000000000000002B:

    2015-04-20 04:51:36.86 spid69 * SegEs: 000000000000002B:

    2015-04-20 04:51:36.86 spid69 * SegFs: 0000000000000053:

    2015-04-20 04:51:36.86 spid69 * SegGs: 000000000000002B:

    2015-04-20 04:51:36.86 spid69 * SegSs: 000000000000002B:

    2015-04-20 04:51:36.86 spid69 * EFlags: 0000000000010212: 000000000000FFFF 0000000000000000 0FA0000000000000 0000000000000000 0080000000000000 0001000000010000

    2015-04-20 04:51:36.86 spid69 * Rax: 0000000000000000:

    2015-04-20 04:51:36.86 spid69 * Rcx: 00000000005A5C40: 4D545FA89792E114 1ED9A321EA2BCD19 A88130C3DF31A1FC A081041F1D550306 81A09A81309D8130 746848869481A097

    2015-04-20 04:51:36.86 spid69 * Rdx: 0000000078D11AA0: FFFFFFFFFFFFFFFF 0053004C00510053 0065007600720065 00610042003A0072 00700075006B0063 0076006500440020

    2015-04-20 04:51:36.86 spid69 * Rbx: 0000007510614160: 0000000000000000 0000000000000000 000000752FEB2170 0000007537E08298 000007FE00000001 0000007537E08298

    2015-04-20 04:51:36.86 spid69 * Rsp: 00000000D86EE2E8: 000007FEDD808E85 0000000000000000 00000000D86EE399 0000000000000000 0000000000000958 00000074C187DF10

    2015-04-20 04:51:36.86 spid69 * Rbp: 00000000D86EE399: 0000000000000000 0000000000000000 FE00000000000000 FAFFFFFFFFFFFFFF 1500000000000000 4000000000000000

    2015-04-20 04:51:36.86 spid69 * Rsi: 0000000000000000:

    2015-04-20 04:51:36.86 spid69 * Rdi: 0000000000000015:

    2015-04-20 04:51:36.86 spid69 * R8: 00000000D86EE370: 0000000078D2E90B 0000000078D298F8 00000074C2026040 000007FE004002B6 0000000000000000 0000000000000000

    2015-04-20 04:51:36.86 spid69 * R9: 000007FEDE6C5520: 0000000078D10000 0000000000000958 006C004700000001 006C00610062006F 004C00510053005C 003000310031005F

    2015-04-20 04:51:36.86 spid69 * R10: 0000000000000019:

    2015-04-20 04:51:36.86 spid69 * R11: 000007FEDE6FD490: 000007FEDE6E4C90 000000752E560040 0000000000000000 0000000000000000 0000000000000000 0000000000000000

    2015-04-20 04:51:36.86 spid69 * R12: 0000000000000019:

    2015-04-20 04:51:36.86 spid69 * R13: 0000000078D2E90B: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000

    2015-04-20 04:51:36.86 spid69 * R14: 00000074C187DF20: 0044005C003A0044 0042005F0079006C 0075006B00630061 0053005C00730070 006F007000700075 0062005F00740072

    2015-04-20 04:51:36.86 spid69 * R15: FFFFFFFFFFFFFFFF:

    2015-04-20 04:51:36.86 spid69 * Rip: 000007FEDB552D45: 104089490904034A C033C300000001B8 000001B810408949 909090C3C033C300 9090909090909090 27A9058B4C909090

    2015-04-20 04:51:36.86 spid69 * *******************************************************************************

    2015-04-20 04:51:36.86 spid69 * -------------------------------------------------------------------------------

    2015-04-20 04:51:36.86 spid69 * Short Stack Dump

    2015-04-20 04:51:36.87 spid69 000007FEDB552D45 Module(sqlmin+00000000009D2D45)

    2015-04-20 04:51:36.87 spid69 000007FEDD808E85 Module(sqlmin+0000000002C88E85)

    2015-04-20 04:51:36.87 spid69 000007FEDDB1BF6F Module(sqlmin+0000000002F9BF6F)

    2015-04-20 04:51:36.88 spid69 000007FEDDB1C29C Module(sqlmin+0000000002F9C29C)

    2015-04-20 04:51:36.88 spid69 000007FEDDAF8614 Module(sqlmin+0000000002F78614)

    2015-04-20 04:51:36.88 spid69 000007FEDDAFAE67 Module(sqlmin+0000000002F7AE67)

    2015-04-20 04:51:36.88 spid69 000007FEDDB20377 Module(sqlmin+0000000002FA0377)

    2015-04-20 04:51:36.88 spid69 000007FEDDB21310 Module(sqlmin+0000000002FA1310)

    2015-04-20 04:51:36.88 spid69 000007FEDDB2D491 Module(sqlmin+0000000002FAD491)

    2015-04-20 04:51:36.89 spid69 000007FEDAC7BC3F Module(sqlmin+00000000000FBC3F)

    2015-04-20 04:51:36.89 spid69 000007FEF61C49D0 Module(sqldk+00000000000049D0)

    2015-04-20 04:51:36.89 spid69 000007FEF61C47B4 Module(sqldk+00000000000047B4)

    2015-04-20 04:51:36.89 spid69 000007FEF61C45B6 Module(sqldk+00000000000045B6)

    2015-04-20 04:51:36.89 spid69 000007FEF61E36FF Module(sqldk+00000000000236FF)

    2015-04-20 04:51:36.89 spid69 000007FEF61E38F0 Module(sqldk+00000000000238F0)

    2015-04-20 04:51:36.89 spid69 000007FEF61E3246 Module(sqldk+0000000000023246)

    2015-04-20 04:51:36.90 spid69 000007FEF61E3558 Module(sqldk+0000000000023558)

    2015-04-20 04:51:36.91 spid69 00000000777F59ED Module(kernel32+00000000000159ED)

    2015-04-20 04:51:36.91 spid69 000000007792C541 Module(ntdll+000000000002C541)

    2015-04-20 04:51:36.92 spid69 Stack Signature for the dump is 0x000000003A4041F2

    2015-04-20 04:51:37.13 spid69 [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 |

    =============================================================================

  • April 20, 2015 at 3:57 am

    #1791962

    If you're getting stack dumps from Access Violations, I would suggest you open a case with Microsoft's customer support people.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 20, 2015 at 4:12 am

    #1791963

    what is case ? how can i open it ? i have MSDN Subscription, is it enough ?

  • April 20, 2015 at 4:17 am

    #1791964

    Call Microsoft Customer Support. Number should be somewhere on Microsoft's web site.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 20, 2015 at 4:29 am

    #1791966

    sreenubabu.s (4/20/2015)

    what is case ? how can i open it ? i have MSDN Subscription, is it enough ?

    Quick question, have you applied any updates to the SQL Server? Quite certain that the same or very similar issue was addressed in Cumulative update package 2 for Microsoft SQL Server 2014[/url]

    😎

  • April 20, 2015 at 5:44 am

    #1791984

    no i did not applied any updates (Current build is 12.0.2000) RTM only.

    as you suggested, can i apply CU2 ?

  • April 20, 2015 at 5:53 am

    #1791987

    sreenubabu.s (4/20/2015)

    no i did not applied any updates (Current build is 12.0.2000) RTM only.

    as you suggested, can i apply CU2 ?

    I do recommend testing and then applying all the Cumulative Updates

    😎

    BTW: Did a quick search and found this

    Solution – SQL Server Backup Failing with EXCEPTION_ACCESS_VIOLATION[/url]

  • April 20, 2015 at 7:21 am

    #1792015

    Hello,

    I had a similar issue when adding a database to a Always on availability group, it would cause an access violation and then crash dump.

    Myself and my DBA manager were completely stumped at the time and we had to contact Microsoft, turns out that 2 databases had the same service broker GUID in sys.databases (no idea how that happened, wasn't our server) and that's what was causing the issue.

    Might be worth checking this out.....

    Also you haven't moved the resource database have you?

    http://sqlserver-help.com/2015/03/25/solution-sql-server-backup-failing-with-exception_access_violation/

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply