积极答复者
添加分区后建立数据库快照失败?

问题
答案
-
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.
- 已标记为答案 Amy PengMicrosoft employee, Moderator 2013年3月18日 1:51
全部回复
-
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 -
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点时建立快照失败,数据文件没有生成 (说明:建立快照前先执行删除操作,再重新建立)
-
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.
- 已标记为答案 Amy PengMicrosoft employee, Moderator 2013年3月18日 1:51