question

Abhijit07 avatar image
Abhijit07 asked

Operating system error 38(Reached the end of the file.) &Msg 1813, Level 16, State 2, Server server1\instance1, Line 1 Could not open new database 'xxxx'. CREATE DATABASE is aborted

On our test server XXXX, I unmounted(detached) snapshot (image name 'Image_0499640') image means you can say mdf and ldf file., then tried to remount(attach) it with different database name, remount failed; so I tried to remount it to a different SQL instance, failed again. Both failed job got the following message, it looks like the database is corrupted. See error details below. " 5241: Device Connector: Failed to mount/clone applications from mapped image. SQL command sqlcmd -S Server1\Instance01 -i C:\Windows\TEMP\6d01-891f-fe82-2b32 -h -1 failed with error Changed language setting to us_english. Changed database context to 'master'. Msg 1813, Level 16, State 2, Server server1\instance1, Line 1 Could not open new database 'xxxx'. CREATE DATABASE is aborted. Msg 823, Level 24, State 5, Server Server1\Instance1, Line 1 The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0x000000bb900000 in file 'V:\Data\xx_log.ldf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. This error can be caused by many factors; for more information, see SQL Server Books Online. Msg 5159, Level 24, State 3, Server Server1\instance1, Line 1 Operating system error 38(Reached the end of the file.) on file "V:\Data\XXXX_log.ldf" during SQLServerLogMgr::ReadFileHdr..

sql server 2017
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.