Snapshot create failure RRS feed

  • 问题

  • 我在服务器里做了一个scheduled Job每隔一个小时重新创建一次snapshot,但是最近每天上午的9:00,这个schedule Job就会fail,并且显示出很多dump log,已经重起过服务器这个问题依旧存在,奇怪的是,当Job fail之后我重新执行一次job就又可以成功创建snapshot,不知道是何种问题,请大家帮忙看看,谢谢了,下面是error log:

    Event Type:    Error
    Event Source:    MSSQLSERVER
    Event Category:    (2)
    Event ID:    17066
    Date:        5/13/2010
    Time:        8:59:05 AM
    User:        NT AUTHORITY\SYSTEM
    Computer:    XXXXX
    SQL Server Assertion: File: <recovery.cpp>, line=3080 Failed Assertion = 'm_recType != REPLICA'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

    For more information, see Help and Support Center at

    2010年5月13日 4:22