Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

SQL Server 2017 MERGE statement assertion error when database is in simple recovery model.

This appears to be identical to an earlier issue with MERGE statements in SQL Server 2014 and 2016, and to feedback closed for SQL Server 2016:

https://feedback.azure.com/forums/908035-sql-server/suggestions/32901826-sql-server-2016-merge-statement-fails-when-runni

When running a MERGE statement against a data warehouse database in simple recovery model, we receive the following fatal error: SQL Server Assertion: File: <pageref.cpp>, line=1496 Failed Assertion = 'IS_OFF (BUF_MINLOGGED, m_buf->bstat) || pageModifyType != PageModifyType_Contents || GetPagePtr ()->IsTextPage ()'.

We are running SQL Server 2017 Standard Edition with CU6 (14.0.3025.34).

A workaround for the assertion error is to set trace flag 692 which disables fast load.

5 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    donaldvc shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base