SQL Server error

  • Has anyone encountered this error before, I couldnt find much documentation online about it. Why do we get this error and what can be done to fix  it(other than restore with latest backup)

    We got this error in Azure SQL VM server with one of the jobs populating the data.

    An internal error occurred while attempting to convert between compressed and uncompressed storage formats.

  • can you supply a little more detail please on exactly what it is you're doing and any error numbers produced from the sql server error log.

    Also, how often is DBCC CHECKDB run on the server, have you run it recently to check the db consistency

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

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

Viewing 2 posts - 1 through 1 (of 1 total)

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