question

PatrykParzoch-1856 avatar image
0 Votes"
PatrykParzoch-1856 asked SeeyaXi-msft commented

Crashed 2TB SSD M.2 disk memory after created backup (.bak) file by SSMS.

Hi!

I have PNY 2TB M.2 PCIe Gen4 NVMe XLR8 CS3040 Heatsink disk. When I run creating .bak file by SSMS (SQL Server Management Studio) direct to M.2 disk. After created .bak file, my memory of M.2 has been corrupted (some files has been lost and installed OS has been corrupted on that disk).
Someone has similar problems with this?

Best regards, Patrick.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PatrykParzoch-1856 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

Sounds like you disk is faulty and you need to replace it. SQL Server does not corrupt the disk, but writing large amount of data, can put a little stress on the disk.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @PatrykParzoch-1856,

Agree with Erland. > SQL Server does not corrupt the disk, but writing large amount of data, can put a little stress on the disk.
If you don't get an error message during the backup process, you should not blame SQL Server for the problem.

Best regards,
Seeya


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.