Creation and start of LocalDB failure

Question

when i run or try to recreate localdb (2014,2019,2022) i get this error message, Creation of LocalDB instance "MSSQLLocalDB" failed because of the following error:

Error occurred during LocalDB instance startup: SQL Server process failed to start. so far what i have tried is:

1. redownload/repair localdb from control panel
2. deleted the folder in C:\Users\lName\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB
3. restarted and repaired anything to do with SQL
4. had a look through info of the local db

Name:

MSSQLLocalDB

Version: 12.0.2000.8 Shared name: Owner: LAPTOP-17VPOCKO\lukeh Auto-create: Yes State: Stopped Instance pipe name:

1. had a look through error logs created:

• error.log
• error1.log

i cant find any solution so far, but i will try my best to find one

Answer 1

I found this error message in the errorlog:

There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:\Users\lukeh\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB\master.mdf.

You are running into a known issue where Windows 11 and SQL Server are at odds with each other. For certain disk drives Windows 11 reports a disk size that SQL Server cannot cope with. Microsoft has published an article with workarounds for the problem.

The errorlog you posted was for the ten-year old SQL 2014. I recommend that you use SQL 2022, the most recent version. Don't forget to download and install the most recent Cumulative Update.