SQL Server error

Question

SQL Server error

cooldude001

Mr or Mrs. 500

Points: 525
More actions
May 15, 2024 at 8:21 am

#4421406

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.

Viewing 4 posts - 1 through 3 (of 3 total)

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

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

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" 😉

cooldude001 Mr or Mrs. 500 Points: 525 More actions · Answer 2

We run CHECKDB job every week and also ran CHECKDB manually after this error, there were no errors.

There is an error logged in SQL log (Error 684 Severity 22). I could see this is one of the errors from below link, not sure what needs to be done as CHECKDB is completing successfully. Issue is Job process is failing with this error intermittently.

https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-events-and-errors-0-to-999?view=sql-server-ver16

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 3

There are a few possible causes, we need some further information!

😎

Quick questions:

was this Error 684 and Severity 22?
Could you please post the output of "SELECT @@VERSION;"
Can you supply the details of the storage configurations?
Could you please supply details on the failing job?