none
添加分区后建立数据库快照失败? RRS feed

  • 问题

  • 使用sql server 2008R2企业版SP2, 启用了数据库镜像,备用库启用了数据库快照功能(通过job每2小时删除旧快照重新生成新快照)。当主数据库执行分区添加数据文件后,紧随其后的镜像库生成快照的job会失败1次,再往后的job执行正常。

    举例:

    1:00    主库执行分区job

    0:00    备库建立新快照 job       正常         

    2:00    备库建立新快照 job       失败  (错误日志中生成很多 stack dump信息)

    4:00    备库建立新快照 job        正常

    后续时间点 备库建立新快照 job   正常  

    2013年3月1日 1:22

答案

全部回复

  • 可以把sql error里的错误信息贴上来吗?

    给我写信: QQ我:点击这里给我发消息

    2013年3月1日 2:43
  • Can you post error in job history?
    2013年3月1日 2:50
  • Date,Source,Severity,Message

    03/01/2013 00:30:08,spid87,Unknown,A system assertion check has failed. Check the SQL Server error log for details. Typically<c/> an assertion failure is caused by a software bug or data corruption. To check for database corruption<c/> consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup<c/> a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.
    03/01/2013 00:30:08,spid87,Unknown,Error: 3624<c/> Severity: 20<c/> State: 1.
    03/01/2013 00:30:08,spid87,Unknown,SQL Server Assertion: File: <recovery.cpp><c/> line=3380 Failed Assertion = 'm_recType != REPLICA'. This error may be timing-related. If the error persists after rerunning the statement<c/> use DBCC CHECKDB to check the database for structural integrity<c/> or restart the server to ensure in-memory data structures are not corrupted.
    03/01/2013 00:30:08,spid87,Unknown,Error: 17066<c/> Severity: 16<c/> State: 1.
    03/01/2013 00:30:08,spid87,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
    03/01/2013 00:30:07,spid87,Unknown,Stack Signature for the dump is 0x0000000131D803F7
    03/01/2013 00:30:07,spid87,Unknown,0000000076D63281 Module(ntdll+0000000000033281)
    03/01/2013 00:30:07,spid87,Unknown,0000000076B2F56D Module(kernel32+000000000001F56D)
    03/01/2013 00:30:07,spid87,Unknown,0000000074313894 Module(MSVCR80+0000000000003894)
    03/01/2013 00:30:07,spid87,Unknown,00000000743137D7 Module(MSVCR80+00000000000037D7)
    03/01/2013 00:30:07,spid87,Unknown,00000000005E59D6 Module(sqlservr+00000000004E59D6)
    03/01/2013 00:30:07,spid87,Unknown,00000000005E8925 Module(sqlservr+00000000004E8925)
    03/01/2013 00:30:07,spid87,Unknown,00000000005E5395 Module(sqlservr+00000000004E5395)
    03/01/2013 00:30:07,spid87,Unknown,00000000005E51DE Module(sqlservr+00000000004E51DE)
    03/01/2013 00:30:07,spid87,Unknown,000000000010AD57 Module(sqlservr+000000000000AD57)
    03/01/2013 00:30:07,spid87,Unknown,000000000010B05E Module(sqlservr+000000000000B05E)
    03/01/2013 00:30:07,spid87,Unknown,000000000010AB94 Module(sqlservr+000000000000AB94)
    03/01/2013 00:30:07,spid87,Unknown,0000000000633DC6 Module(sqlservr+0000000000533DC6)
    03/01/2013 00:30:07,spid87,Unknown,000000000068C800 Module(sqlservr+000000000058C800)
    03/01/2013 00:30:07,spid87,Unknown,000000000068AC8C Module(sqlservr+000000000058AC8C)
    03/01/2013 00:30:07,spid87,Unknown,000000000068B3D7 Module(sqlservr+000000000058B3D7)
    03/01/2013 00:30:07,spid87,Unknown,0000000000687A2D Module(sqlservr+0000000000587A2D)
    03/01/2013 00:30:07,spid87,Unknown,0000000001601F25 Module(sqlservr+0000000001501F25)
    03/01/2013 00:30:07,spid87,Unknown,0000000001603F16 Module(sqlservr+0000000001503F16)
    03/01/2013 00:30:07,spid87,Unknown,00000000016045BC Module(sqlservr+00000000015045BC)
    03/01/2013 00:30:07,spid87,Unknown,000000000068AC8C Module(sqlservr+000000000058AC8C)
    03/01/2013 00:30:07,spid87,Unknown,000000000068B3D7 Module(sqlservr+000000000058B3D7)
    03/01/2013 00:30:07,spid87,Unknown,0000000000687A2D Module(sqlservr+0000000000587A2D)
    03/01/2013 00:30:07,spid87,Unknown,00000000016022F9 Module(sqlservr+00000000015022F9)
    03/01/2013 00:30:07,spid87,Unknown,000000000160646E Module(sqlservr+000000000150646E)
    03/01/2013 00:30:07,spid87,Unknown,000000000068AC8C Module(sqlservr+000000000058AC8C)
    03/01/2013 00:30:07,spid87,Unknown,000000000068B3D7 Module(sqlservr+000000000058B3D7)
    03/01/2013 00:30:07,spid87,Unknown,0000000000687A2D Module(sqlservr+0000000000587A2D)
    03/01/2013 00:30:07,spid87,Unknown,000000000139C584 Module(sqlservr+000000000129C584)
    03/01/2013 00:30:07,spid87,Unknown,00000000015EC973 Module(sqlservr+00000000014EC973)
    03/01/2013 00:30:07,spid87,Unknown,00000000015EE220 Module(sqlservr+00000000014EE220)
    03/01/2013 00:30:07,spid87,Unknown,00000000020208A0 Module(sqlservr+0000000001F208A0)
    03/01/2013 00:30:07,spid87,Unknown,000000000202259C Module(sqlservr+0000000001F2259C)
    03/01/2013 00:30:07,spid87,Unknown,000000000203C3C2 Module(sqlservr+0000000001F3C3C2)
    03/01/2013 00:30:07,spid87,Unknown,000000000222D3A2 Module(sqlservr+000000000212D3A2)
    03/01/2013 00:30:07,spid87,Unknown,00000000022120D4 Module(sqlservr+00000000021120D4)
    03/01/2013 00:30:07,spid87,Unknown,00000000022172D6 Module(sqlservr+00000000021172D6)
    03/01/2013 00:30:07,spid87,Unknown,0000000001E4CB94 Module(sqlservr+0000000001D4CB94)
    03/01/2013 00:30:07,spid87,Unknown,00000000021DDC86 Module(sqlservr+00000000020DDC86)
    03/01/2013 00:30:07,spid87,Unknown,00000000021D974D Module(sqlservr+00000000020D974D)
    03/01/2013 00:30:07,spid87,Unknown,000007FEFCFBAA7D Module(KERNELBASE+000000000000AA7D)
    03/01/2013 00:30:07,spid87,Unknown,* Short Stack Dump
    03/01/2013 00:30:07,spid87,Unknown,* -------------------------------------------------------------------------------
    03/01/2013 00:30:07,spid87,Unknown,* *******************************************************************************
    03/01/2013 00:30:07,spid87,Unknown,*        Rip: 000007FEFCFBAA7D:  C3000000C8C48148  9090909090909090  8348EC8348909090  00016A428D0F08F9  74894858245C8948  4D30247C89483824
    03/01/2013 00:30:07,spid87,Unknown,*        R15: 000000000000003F:
    03/01/2013 00:30:07,spid87,Unknown,*        R14: 000000005B7B9E80:  00610063006F004C  006E006F00690074  007200200009003A  0076006F00630065  002E007900720065  003A007000700063
    03/01/2013 00:30:07,spid87,Unknown,*        R13: 0000000711982EA0:  0000000711982080  00000007119823B0  0000000711982AD0  0000000711983E50  0000000711982F10  00000000A0587510
    03/01/2013 00:30:07,spid87,Unknown,*        R12: 0000000000000001:
    03/01/2013 00:30:07,spid87,Unknown,*        R11: 000000005B7B8FD0:  002E0036002E0031  0000000000000033  0000000000440042  00000000569431B8  0000000000000042  0000000076D84B18
    03/01/2013 00:30:07,spid87,Unknown,*        R10: 0000000000000000:
    03/01/2013 00:30:07,spid87,Unknown,*         R9: 0000000000000000:
    03/01/2013 00:30:07,spid87,Unknown,*         R8: 0000000000000000:
    03/01/2013 00:30:07,spid87,Unknown,*        Rdi: 000000005B7B89F0:  00000000569431B0  0000000000000000  000000005B7B8A30  0000000080895B50  000000005B7B8DB8  00000000040C0040
    03/01/2013 00:30:07,spid87,Unknown,*        Rsi: 0000000711983EC0:  0000000711983EC0  0000000711982EA0  0000000000000000  0000000000000000  0000000711983EE0  0000000711983EE0
    03/01/2013 00:30:07,spid87,Unknown,*        Rbp: 000000005B7B9F40:  000003E500000D34  0000000100000001  00000000FFFFFFFF  0000000003A90AC8  000000000000005B  00000000005F6B8C
    03/01/2013 00:30:07,spid87,Unknown,*        Rsp: 000000005B7B87C0:  0000000000000000  0000000711983EC0  000000005B7B89F0  0000000000000000  00000000000042AC  0000000000000000
    03/01/2013 00:30:07,spid87,Unknown,*        Rbx: 0000000000000000:
    03/01/2013 00:30:07,spid87,Unknown,*        Rdx: 0000000000000000:
    03/01/2013 00:30:07,spid87,Unknown,*        Rcx: 000000005B7B81B0:  002E0036002E0031  0000000000000033  0000000000440042  00000000569431B8  0000000000000042  0000000076D84B18
    03/01/2013 00:30:07,spid87,Unknown,*        Rax: 0000000013079D15:
    03/01/2013 00:30:07,spid87,Unknown,*     EFlags: 0000000000000202:
    03/01/2013 00:30:07,spid87,Unknown,*      SegSs: 000000000000002B:
    03/01/2013 00:30:07,spid87,Unknown,*      SegGs: 000000000000002B:
    03/01/2013 00:30:07,spid87,Unknown,*      SegFs: 0000000000000053:
    03/01/2013 00:30:07,spid87,Unknown,*      SegEs: 000000000000002B:
    03/01/2013 00:30:07,spid87,Unknown,*      SegDs: 000000000000002B:
    03/01/2013 00:30:07,spid87,Unknown,*      SegCs: 0000000000000033:
    03/01/2013 00:30:07,spid87,Unknown,*      MxCsr: 0000000000001FA0:
    03/01/2013 00:30:07,spid87,Unknown,* ContextFlags: 000000000010000F:  000000000000B800  0000000000004000  0000000000000000  0000000000000000  0000000000000000  0001000000000000
    03/01/2013 00:30:07,spid87,Unknown,*     P6Home: 0000000076D84B18:  4100000120C48148  5F5C415D415E415F  48C1B70F41C35B5E  8D48E8D14802C183  0F3973C83B484304  836620C8836601B7
    03/01/2013 00:30:07,spid87,Unknown,*     P5Home: 0000000000000042:
    03/01/2013 00:30:07,spid87,Unknown,*     P4Home: 00000000569431B8:  0073005C003A0065  00610064006C0071  0065005C00610074  006F006C00720072  00510053005C0067  006D00750044004C
    03/01/2013 00:30:07,spid87,Unknown,*     P3Home: 0000000000440042:  00414B6C840F0110  0B84850F02107D83  7B840F7C5D390000  F38B44FB8B00000B  00A424B48BEB8B4C  6C8E0FF33B480000
    03/01/2013 00:30:07,spid87,Unknown,*     P2Home: 0000000000000033:
    03/01/2013 00:30:07,spid87,Unknown,*     P1Home: 002E0036002E0031:
    03/01/2013 00:30:07,spid87,Unknown,*
    03/01/2013 00:30:07,spid87,Unknown,* dbghelp                        00000000708B0000  0000000070A0DFFF  0015e000
    03/01/2013 00:30:07,spid87,Unknown,* xplog70                        0000000073010000  0000000073011FFF  00002000
    03/01/2013 00:30:07,spid87,Unknown,* xplog70                        0000000073780000  000000007378FFFF  00010000
    03/01/2013 00:30:07,spid87,Unknown,* xpstar                         0000000073790000  00000000737B4FFF  00025000
    03/01/2013 00:30:07,spid87,Unknown,* resutils                       000007FEF4260000  000007FEF4278FFF  00019000
    03/01/2013 00:30:07,spid87,Unknown,* clusapi                        000007FEF4280000  000007FEF42CFFFF  00050000
    03/01/2013 00:30:07,spid87,Unknown,* odbcint                        00000000738F0000  0000000073927FFF  00038000
    03/01/2013 00:30:07,spid87,Unknown,* ATL80                          0000000073D30000  0000000073D4FFFF  00020000
    03/01/2013 00:30:07,spid87,Unknown,* ODBC32                         000007FEF42F0000  000007FEF439EFFF  000af000
    03/01/2013 00:30:07,spid87,Unknown,* SQLSCM                         0000000073CE0000  0000000073CEDFFF  0000e000
    03/01/2013 00:30:07,spid87,Unknown,* xpstar                         0000000072CC0000  0000000072D47FFF  00088000
    03/01/2013 00:30:07,spid87,Unknown,* xpsqlbot                       0000000073870000  0000000073877FFF  00008000
    03/01/2013 00:30:07,spid87,Unknown,* netbios                        000007FEF2780000  000007FEF2789FFF  0000a000
    03/01/2013 00:30:07,spid87,Unknown,* SQLNCLIR10                     0000000072D50000  0000000072D86FFF  00037000
    03/01/2013 00:30:07,spid87,Unknown,* COMDLG32                       000007FEFEF20000  000007FEFEFB7FFF  00098000
    03/01/2013 00:30:07,spid87,Unknown,* COMCTL32                       000007FEFCD40000  000007FEFCDDFFFF  000a0000
    03/01/2013 00:30:07,spid87,Unknown,* sqlncli10                      0000000069230000  00000000694ECFFF  002bd000
    03/01/2013 00:30:07,spid87,Unknown,* CLBCatQ                        000007FEFEE80000  000007FEFEF18FFF  00099000
    03/01/2013 00:30:07,spid87,Unknown,* bcryptprimitives               000007FEFC120000  000007FEFC16BFFF  0004c000
    03/01/2013 00:30:07,spid87,Unknown,* fwpuclnt                       000007FEFA420000  000007FEFA472FFF  00053000
    03/01/2013 00:30:07,spid87,Unknown,* rasadhlp                       000007FEF9A40000  000007FEF9A47FFF  00008000
    03/01/2013 00:30:07,spid87,Unknown,* DNSAPI                         000007FEFC2B0000  000007FEFC30AFFF  0005b000
    03/01/2013 00:30:07,spid87,Unknown,* ntdsapi                        000007FEF4F80000  000007FEF4FA6FFF  00027000
    03/01/2013 00:30:07,spid87,Unknown,* wshtcpip                       000007FEFBEC0000  000007FEFBEC6FFF  00007000
    03/01/2013 00:30:07,spid87,Unknown,* wship6                         000007FEFC6E0000  000007FEFC6E6FFF  00007000
    03/01/2013 00:30:07,spid87,Unknown,* mswsock                        000007FEFC420000  000007FEFC473FFF  00054000
    03/01/2013 00:30:07,spid87,Unknown,* bcrypt                         000007FEFC660000  000007FEFC681FFF  00022000
    03/01/2013 00:30:07,spid87,Unknown,* ncrypt                         000007FEFC690000  000007FEFC6DDFFF  0004e000
    03/01/2013 00:30:07,spid87,Unknown,* WINTRUST                       000007FEFCDE0000  000007FEFCE18FFF  00039000
    03/01/2013 00:30:07,spid87,Unknown,* dbghelp                        0000000073B00000  0000000073C5DFFF  0015e000
    03/01/2013 00:30:07,spid87,Unknown,* VERSION                        000007FEFBDF0000  000007FEFBDFBFFF  0000c000
    03/01/2013 00:30:07,spid87,Unknown,* MSFTE                          0000000049980000  0000000049D2DFFF  003ae000
    03/01/2013 00:30:07,spid87,Unknown,* ftimport                       0000000060000000  0000000060024FFF  00025000
    03/01/2013 00:30:07,spid87,Unknown,* OLEAUT32                       000007FEFEDA0000  000007FEFEE76FFF  000d7000
    03/01/2013 00:30:07,spid87,Unknown,* SHELL32                        000007FEFDD10000  000007FEFEA95FFF  00d86000
    03/01/2013 00:30:07,spid87,Unknown,* WS2_32                         000007FEFD2E0000  000007FEFD32CFFF  0004d000
    03/01/2013 00:30:07,spid87,Unknown,* security                       0000000074240000  0000000074242FFF  00003000
    03/01/2013 00:30:07,spid87,Unknown,* CRYPT32                        000007FEFCE40000  000007FEFCFA5FFF  00166000
    03/01/2013 00:30:07,spid87,Unknown,* schannel                       000007FEFC250000  000007FEFC2A8FFF  00059000
    03/01/2013 00:30:07,spid87,Unknown,* MSASN1                         000007FEFCD30000  000007FEFCD3EFFF  0000f000
    03/01/2013 00:30:07,spid87,Unknown,* kerberos                       000007FEFC530000  000007FEFC5E2FFF  000b3000
    03/01/2013 00:30:07,spid87,Unknown,* cryptdll                       000007FEFC870000  000007FEFC883FFF  00014000
    03/01/2013 00:30:07,spid87,Unknown,* msv1_0                         000007FEFC3C0000  000007FEFC410FFF  00051000
    03/01/2013 00:30:07,spid87,Unknown,* credssp                        000007FEFC480000  000007FEFC488FFF  00009000
    03/01/2013 00:30:07,spid87,Unknown,* ole32                          000007FEFD0D0000  000007FEFD2D0FFF  00201000
    03/01/2013 00:30:07,spid87,Unknown,* MSCOREE                        000007FEF8CD0000  000007FEF8D35FFF  00066000
    03/01/2013 00:30:07,spid87,Unknown,* AUTHZ                          000007FEFC6F0000  000007FEFC71EFFF  0002f000
    03/01/2013 00:30:07,spid87,Unknown,* BROWCLI                        000007FEF82B0000  000007FEF82C1FFF  00012000
    03/01/2013 00:30:07,spid87,Unknown,* CRYPTBASE                      000007FEFCB80000  000007FEFCB8EFFF  0000f000
    03/01/2013 00:30:07,spid87,Unknown,* rsaenh                         000007FEFC1C0000  000007FEFC206FFF  00047000
    03/01/2013 00:30:07,spid87,Unknown,* CRYPTSP                        000007FEFC4E0000  000007FEFC4F6FFF  00017000
    03/01/2013 00:30:07,spid87,Unknown,* WLDAP32                        000007FEFD410000  000007FEFD45FFFF  00050000
    03/01/2013 00:30:07,spid87,Unknown,* ntmarta                        000007FEFBDC0000  000007FEFBDECFFF  0002d000
    03/01/2013 00:30:07,spid87,Unknown,* sqlevn70                       000000006F790000  000000006F993FFF  00204000
    03/01/2013 00:30:07,spid87,Unknown,* sqlevn70                       0000000073D50000  0000000073E3CFFF  000ed000
    03/01/2013 00:30:07,spid87,Unknown,* cscapi                         000007FEF8CC0000  000007FEF8CCEFFF  0000f000
    03/01/2013 00:30:07,spid87,Unknown,* instapi10                      00000000741A0000  00000000741ACFFF  0000d000
    03/01/2013 00:30:07,spid87,Unknown,* psapi                          0000000076EF0000  0000000076EF6FFF  00007000
    03/01/2013 00:30:07,spid87,Unknown,* MSCTF                          000007FEFEC90000  000007FEFED98FFF  00109000
    03/01/2013 00:30:07,spid87,Unknown,* IMM32                          000007FEFD7B0000  000007FEFD7DDFFF  0002e000
    03/01/2013 00:30:07,spid87,Unknown,* BatchParser                    0000000073EA0000  0000000073ECCFFF  0002d000
    03/01/2013 00:30:07,spid87,Unknown,* SAMCLI                         000007FEF9B40000  000007FEF9B53FFF  00014000
    03/01/2013 00:30:07,spid87,Unknown,* LOGONCLI                       000007FEFC4B0000  000007FEFC4DFFFF  00030000
    03/01/2013 00:30:07,spid87,Unknown,* wkscli                         000007FEFA1E0000  000007FEFA1F4FFF  00015000
    03/01/2013 00:30:07,spid87,Unknown,* srvcli                         000007FEFC730000  000007FEFC752FFF  00023000
    03/01/2013 00:30:07,spid87,Unknown,* netutils                       000007FEFA200000  000007FEFA20BFFF  0000c000
    03/01/2013 00:30:07,spid87,Unknown,* NETAPI32                       000007FEFA210000  000007FEFA225FFF  00016000
    03/01/2013 00:30:07,spid87,Unknown,* opends60                       0000000073ED0000  0000000073ED7FFF  00008000
    03/01/2013 00:30:07,spid87,Unknown,* WINNSI                         000007FEFA670000  000007FEFA67AFFF  0000b000
    03/01/2013 00:30:07,spid87,Unknown,* NSI                            000007FEFD500000  000007FEFD507FFF  00008000
    03/01/2013 00:30:07,spid87,Unknown,* IPHLPAPI                       000007FEFA4A0000  000007FEFA4C6FFF  00027000
    03/01/2013 00:30:07,spid87,Unknown,* WINMM                          000007FEF8D40000  000007FEF8D7AFFF  0003b000
    03/01/2013 00:30:07,spid87,Unknown,* profapi                        000007FEFCC90000  000007FEFCC9EFFF  0000f000
    03/01/2013 00:30:07,spid87,Unknown,* USERENV                        000007FEFC080000  000007FEFC09DFFF  0001e000
    03/01/2013 00:30:07,spid87,Unknown,* USP10                          000007FEFD640000  000007FEFD709FFF  000ca000
    03/01/2013 00:30:07,spid87,Unknown,* LPK                            000007FEFEAA0000  000007FEFEAADFFF  0000e000
    03/01/2013 00:30:07,spid87,Unknown,* USER32                         0000000076C30000  0000000076D29FFF  000fa000
    03/01/2013 00:30:07,spid87,Unknown,* GDI32                          000007FEFD060000  000007FEFD0C6FFF  00067000
    03/01/2013 00:30:07,spid87,Unknown,* SHLWAPI                        000007FEFEFC0000  000007FEFF030FFF  00071000
    03/01/2013 00:30:07,spid87,Unknown,* pdh                            000007FEF8D80000  000007FEF8DCDFFF  0004e000
    03/01/2013 00:30:07,spid87,Unknown,* SSPICLI                        000007FEFCAE0000  000007FEFCB04FFF  00025000
    03/01/2013 00:30:07,spid87,Unknown,* Secur32                        000007FEFC840000  000007FEFC84AFFF  0000b000
    03/01/2013 00:30:07,spid87,Unknown,* sqlos                          0000000073EE0000  0000000073EE6FFF  00007000
    03/01/2013 00:30:07,spid87,Unknown,* MSVCP80                        0000000073F80000  0000000074088FFF  00109000
    03/01/2013 00:30:07,spid87,Unknown,* MSVCR80                        0000000074310000  00000000743D8FFF  000c9000
    03/01/2013 00:30:07,spid87,Unknown,* RPCRT4                         000007FEFDBE0000  000007FEFDD0DFFF  0012e000
    03/01/2013 00:30:07,spid87,Unknown,* sechost                        000007FEFDA40000  000007FEFDA5EFFF  0001f000
    03/01/2013 00:30:07,spid87,Unknown,* msvcrt                         000007FEFD460000  000007FEFD4FEFFF  0009f000
    03/01/2013 00:30:07,spid87,Unknown,* ADVAPI32                       000007FEFD330000  000007FEFD40AFFF  000db000
    03/01/2013 00:30:07,spid87,Unknown,* KERNELBASE                     000007FEFCFB0000  000007FEFD01AFFF  0006b000
    03/01/2013 00:30:07,spid87,Unknown,* kernel32                       0000000076B10000  0000000076C2EFFF  0011f000
    03/01/2013 00:30:07,spid87,Unknown,* ntdll                          0000000076D30000  0000000076EDAFFF  001ab000
    03/01/2013 00:30:07,spid87,Unknown,* sqlservr                       0000000000100000  0000000003D11FFF  03c12000
    03/01/2013 00:30:07,spid87,Unknown,*  MODULE                          BASE      END       SIZE
    03/01/2013 00:30:07,spid87,Unknown,*
    03/01/2013 00:30:07,spid87,Unknown,*
    03/01/2013 00:30:07,spid87,Unknown,*  G:\Snapshots'<c/> @postfix='ss';
    03/01/2013 00:30:07,spid87,Unknown,*  exec dbo.sp_generate_snapshot 'db01'<c/> @exec=1<c/> @save_path='G
    03/01/2013 00:30:07,spid87,Unknown,*  ot 'db01'<c/> @exec=1<c/> @save_path='G:\Snapshots'<c/> @postfix='ss';
    03/01/2013 00:30:07,spid87,Unknown,*  h='G:\Snapshots'<c/> @postfix='ss';  exec dbo.sp_generate_snapsh
    03/01/2013 00:30:07,spid87,Unknown,*   exec dbo.sp_generate_snapshot 'db02'<c/> @exec=1<c/> @save_pat
    03/01/2013 00:30:07,spid87,Unknown,*  apshot 'db03'<c/> @exec=1<c/> @save_path='G:\Snapshots'<c/> @postfix='ss';
    03/01/2013 00:30:07,spid87,Unknown,*  _path='G:\Snapshots'<c/> @postfix='ss';  exec  dbo.sp_generate_sn
    03/01/2013 00:30:07,spid87,Unknown,*             exec  dbo.sp_generate_snapshot 'db04'<c/> @exec=1<c/> @save
    03/01/2013 00:30:07,spid87,Unknown,* Input Buffer 510 bytes -
    03/01/2013 00:30:07,spid87,Unknown,*
    03/01/2013 00:30:07,spid87,Unknown,* Process ID: 6608
    03/01/2013 00:30:07,spid87,Unknown,* SPID: 87
    03/01/2013 00:30:07,spid87,Unknown,* Expression: m_recType != REPLICA
    03/01/2013 00:30:07,spid87,Unknown,* Location: recovery.cpp:3380
    03/01/2013 00:30:07,spid87,Unknown,*
    03/01/2013 00:30:07,spid87,Unknown,*   03/01/13 00:30:07 spid 87
    03/01/2013 00:30:07,spid87,Unknown,* BEGIN STACK DUMP:
    03/01/2013 00:30:07,spid87,Unknown,*
    03/01/2013 00:30:07,spid87,Unknown,* *******************************************************************************
    03/01/2013 00:30:07,spid87,Unknown,***Stack Dump being sent to e:\errlog\SQLDump0078.txt
    2013年3月1日 3:08
  • What's error in job history? Were all new files created on mirror partner when generate snapshot at 2am?
    2013年3月1日 3:15
  • use DBCC CHECKDB to check the database for structural integrity<c/> or restart the server to ensure in-memory data structures are not corrupted.

    不知道是不是你的镜像库已经损坏了,LZ可以checkdb看一下


    给我写信: QQ我:点击这里给我发消息

    2013年3月1日 3:59
  • 先前执行过DBCC CHECKDB,没有错误。 

    如果镜像库损坏的话,后面间隔两小时的重建快照也应该错误才对。

    2013年3月1日 5:19
  • job历史:

    (Error 1823)  A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support. [SQLSTATE HY000] (Error 3624)  create database xxx on  (name = 'xxx',filename = 'G:\Snapshots\xxx.ss'),  (name = 'xxx01',filename = 'G:\Snapshots\xxx1.ss'),  (name = 'xxx02',filename = 'G:\Snapshots\xxx2.ss'),  (name = 'xxx03',filename = 'G:\Snapshots\xxx3.ss'),  (name = 'xxx04',filename = 'G:\Snapshots\xxx4.ss'),  (name = 'xxx05',filename = 'G:\Snapshots\xxx05.ss'),  (name = 'xxx06',filename = 'G:\Snapshots\xxx06.ss'),  (name = 'xxx07',filename = 'G:\Snapshots\xxx07.ss'),  (name = 'xxx08',filename = 'G:\Snapshots\xxx08.ss'),  (name = 'xxx09',filename = 'G:\Snapshots\xxx09.ss'),  (name = 'xxx10',filename = 'G:\Snapshots\xxx10.ss'),  (name = 'xxx11',filename = 'G:\Snapshots\xxx11.ss'),  (name = 'xxx12',filename = 'G:\Snapshots\xxx12.ss'),  (name = 'xxx13',filename = 'G:\Snapshots\xxx13.ss'),  (name = 'xxx14',filename = 'G:\Snapshots\xxx14.ss'),  (name = 'xxx15',filename = 'G:\Snapshots\xxx15.ss')  as snapshot of xxx [SQLSTATE 01000] (Error 0)  Location: recovery.cpp:3380 Expression: m_recType != REPLICA SPID: 88 Process ID: 6608 [SQLSTATE 01000] (Error 3624).  The step failed.

    2点时建立快照失败,数据文件没有生成 (说明:建立快照前先执行删除操作,再重新建立)

    2013年3月1日 5:26
  • 补充说明:10几个要分区的数据库都碰到过这现象。

    当主数据库不添加分区(分区后要添加数据文件)时,镜像库建立新快照一直都正常,只要主库添加分区,镜像服务器在分区时间点后执行建立快照肯定失败,过了这段时间随意建立快照都没问题。



    2013年3月1日 5:35
  • Are those snapshot files match db files? Sounds to me that partition didn't complete on mirror partner yet while snapshot creation job kicks in.

    2013年3月1日 13:59