Error when backup database SQL to sofs shared folder

Huynh Minh Ngon 0

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?

Huynh Minh Ngon 0 Reputation points

2024-12-17T11:42:37.7233333+00:00

This is my dump logSQLDump0028.txt
Huynh Minh Ngon 0 Reputation points

2024-12-17T11:43:04.8+00:00

SQLDump0028.txt this is my dump log
Viorel 118.8K Reputation points

2024-12-17T19:25:40.9+00:00
Probably it is not a recent issue:

https://learn.microsoft.com/en-us/answers/questions/94751/

Did you try to use another destination disk?
Huynh Minh Ngon 0 Reputation points

2024-12-18T01:29:16.06+00:00

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?
Erland Sommarskog 114.9K Reputation points MVP

2024-12-18T22:15:29.3633333+00:00

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?
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Huynh Minh Ngon 0 Reputation points

2024-12-19T01:20:04.8966667+00:00
Scenario

SQL Server: Running in a SQL FCI (Failover Cluster Instance) guest cluster.

Backup Requirement: Need to back up directly to an SOFS (Scale-Out File Server) shared folder.

Infrastructure:

Hyper-V Cluster uses Storage Spaces Direct (S2D).

SOFS is configured in the Hyper-V Cluster to manage shared storage.

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:

Permissions for the SQL Server service account are configured correctly.

The SOFS share is accessible via 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
Huynh Minh Ngon 0 Reputation points

2024-12-19T01:22:11.6+00:00

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!

4 answers

Erland Sommarskog 114.9K Reputation points MVP

2024-12-17T22:03:39.9033333+00:00
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?
Please sign in to rate this answer.
Huynh Minh Ngon 0 Reputation points

2024-12-18T01:35:24.55+00:00

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.

Huynh Minh Ngon 0 Reputation points

2024-12-18T03:44:54.3766667+00:00

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!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
ZoeHui-MSFT 39,346 Reputation points

2024-12-18T01:58:55.8433333+00:00

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:

Services Hub (microsoft.com)

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.
Please sign in to rate this answer.
Huynh Minh Ngon 0 Reputation points

2024-12-18T04:40:16.35+00:00

I input my info to form and submit, The error is show. Any solution to open ticket to get support from Microsoft?

ZoeHui-MSFT 39,346 Reputation points

2024-12-18T06:11:56.0666667+00:00

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.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Zhou, Yun (CMOC) 0 Reputation points

2024-12-18T07:18:53.91+00:00

Have you tried accessing your local disk?Current bak command is stored in a shared folder.

Bert
Please sign in to rate this answer.
Huynh Minh Ngon 0 Reputation points

2024-12-19T01:16:17.34+00:00

Scenario

SQL Server: Running in a SQL FCI (Failover Cluster Instance) guest cluster.

Backup Requirement: Need to back up directly to an SOFS (Scale-Out File Server) shared folder.

Infrastructure:

Hyper-V Cluster uses Storage Spaces Direct (S2D).

SOFS is configured in the Hyper-V Cluster to manage shared storage.

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:

Permissions for the SQL Server service account are configured correctly.

The SOFS share is accessible via 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.

Erland Sommarskog 114.9K Reputation points MVP

2024-12-19T21:50:06.56+00:00

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.

Huynh Minh Ngon 0 Reputation points

2024-12-20T01:35:29.7466667+00:00

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!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
John Marlow 0 Reputation points

2024-12-19T13:17:56.07+00:00

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!
Please sign in to rate this answer.
Erland Sommarskog 114.9K Reputation points MVP

2024-12-19T21:50:24.7433333+00:00

Interesting, John. Can you share more details?

Huynh Minh Ngon 0 Reputation points

2024-12-20T01:49:03.8833333+00:00

Dear John,

I haven't support plan to create ticket to Microsoft Support.

Can you help me to send dump file or something else to Microsoft?

And Could you please notify to me when the bug is fixed?

I have new project to build 2 SQL FCI at DC (Datacenter) site and DR (Disaster recovery) site. All database in 2 SQL FCI will setting Transaction Log Shipping to SOFS shared folder and recovering to another SQL FCI. Right now, my project is delayed 3 days. Because my SQL FCI can't backup log to SOFS shared folder.
Hoping for help from everyone. Thank you!

Erland Sommarskog 114.9K Reputation points MVP

2024-12-20T22:17:14.2833333+00:00

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.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Error when backup database SQL to sofs shared folder

4 answers

Your answer