This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 54%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
BACKUP DATABASE testbackup TO DISK = N'\sofs01\SQL\1.bak'
when i run this sql command, i have error:
Location: mediaWrite.cpp:601
Expression: (m_pWriteBuffer->GetCurrentSize ()% GetBlockSize ()) == 0
SPID: 56
Process ID: 9276
Thread ID: 10672
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Msg 3624, Level 20, State 1, Line 1
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 Hotfix from Technical Support.
Completion time: 2024-12-17T18:29:23.5033805+07:00
I another sql server. I can run sql command to backup successfully.
this is my sql version
Microsoft SQL Server 2022 (RTM-CU16) (KB5048033) - 16.0.4165.4 (X64) Nov 6 2024 19:24:49 Copyright (C) 2022 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)
How to fix this bug?
Additional SQL Server features and topics not covered by specific categories
This is my dump logSQLDump0028.txt
Probably it is not a recent issue:
Did you try to use another destination disk?
Shared folder from another VM is OK for backup. But I would like to used scale out file server in here. The \IDC-G03-SOFS01\SQL is the shared folder on the scale out file server. Maybe SQL server can't backup to SOFS?
Maybe SQL server can't backup to SOFS?
Pardon my ignorance, but what is SOFS in this context? I thought it was just a server in your environment. Or is SOFS something else like a file system?
Scenario
Findings
Backup to Local Disk: Works successfully.
Backup to a Shared Folder (Non-SOFS): Works successfully from the SQL Server guest cluster.
Backup to SOFS Shared Folder: Fails, even though:
Test-Path and xp_cmdshell.Transaction Log Shipping: Intended to use the SOFS shared folder as the destination for log backups but fails with the same issue.
File Server Role Test: Creating a File Server role in the Hyper-V Cluster and testing backup to it also fails.
Goal
Configure SQL Server transaction log shipping and direct backups to an SOFS shared folder managed by the Hyper-V Cluster using S2D.Scenario
SOFS is Scale Out File Server role in Hyper-V Cluster. I will describe my system in last post. Please read it and assist me. Thank you!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 38%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
This bug involves all SQL used by Microsoft as of the Dec. 5th update. It affects MS Access, PowerShell, Visual Studio, etc.
Please report this bug as I have to help Microsoft narrow down the cause.
Thank you!
Interesting, John. Can you share more details?
Dear John,
It strikes me a little odd that if you are building a data centre that you, or the organisation you are working for, do not have a support contract.
But even if you had, and you could open a case, the solution may not be immediate. Well, if it is some sort of configuration, it might be. But if it is a bug, it may take some time before Microsoft has a fix.
So you may have no choice to think of a plan B no matter what.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 62%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZY%3C/text%3E%3C/svg%3E)
Have you tried accessing your local disk?Current bak command is stored in a shared folder.
Bert
Scenario
Findings
Backup to Local Disk: Works successfully.
Backup to a Shared Folder (Non-SOFS): Works successfully from the SQL Server guest cluster.
Backup to SOFS Shared Folder: Fails, even though:
Test-Path and xp_cmdshell.Transaction Log Shipping: Intended to use the SOFS shared folder as the destination for log backups but fails with the same issue.
File Server Role Test: Creating a File Server role in the Hyper-V Cluster and testing backup to it also fails.
Goal
Configure SQL Server transaction log shipping and direct backups to an SOFS shared folder managed by the Hyper-V Cluster using S2D.
OK, I thought that SOFS might be some fancy file system. From what you describe, it sounds like something that should work. But it is definitely not my area, so I can't help much.
But as I said, the error message as such is a bug, and the best would be to sort it out with Microsoft Support. But that requires that your organisation has a good support contract.
I trying create ticket to Microsoft Support, but i haven't support plan, I only have SQL standard key only. Thank you for your assist!
Hi @Huynh Minh Ngon,
Noticed that you have get the dump file and you are using Standard version.
You may send the dump file to Microsoft to get directly help.
Open a ticket to Microsoft support:
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
I input my info to form and submit, The error is show. Any solution to open ticket to get support from Microsoft?
Hi @Huynh Minh Ngon,
Customers with a Premier or Unified support plan can open a ticket with Microsoft support.
Customers with a Professional or Business support plan can open a ticket with Microsoft support.
Or you may contact the IM or CSAM.
The error message as such is a bug in SQL Server. An assertion error is due to that in the program code there is an assertion check saying that "at this point, this condition is assumed to be true, and if it is not, we no longer know what we are doing, and we should get out of hear real quick, before we cause any more damage" and then they terminate your process.
Since you have the most recent CU of SQL Server 2022, the correct action would be to open a support case. This assume that you have some form of support contract.
I should make it clear that this is necessarily a bug in the meaning "this should work". The essence of the bug might just be that they should produce a normal error message without terminating the process.
If I am to make any guess, I would run this command:
fsutil fsinfo sectorinfo <volume pathname>
On the machine hosting the share, replacing the angle bracketed part with the drive for the share. If any number is > 4096, this may be the problem.
And, oh, if this is a share, shouldn't there be two backslashes in the beginning of the path?
fsutil fsinfo sectorinfo <volume pathname>
This command can run for CSVFS_NTFS volume? Because SOFS shared folder is Scale out file server. When I backup to shared folder from the Virtual Machine, backup is success.
Sorry for my bad English.
After remove and recreate the SOFS, Another SQL Server can backup success. Only The new SQL server 2022 CU 16 can't backup. Any solution to trace the error. Thank you!