service sql server not starting

SQL Server Administration
1

hello all, my sql server service are not starting , when i saw log file i find this error

2025-01-14 09:16:13.54 spid9s Starting up database 'model'.
2025-01-14 09:16:13.77 spid9s Error: 9003, Severity: 20, State: 1.
2025-01-14 09:16:13.77 spid9s The log scan number (67:440:1) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
2025-01-14 09:16:13.77 spid9s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

i have no backup ,

2

This might help get SQL Server runnning:
disaster recovery - How to start MSSQL Server with corrupt model db - Server Fault

You also need to check the Windows logs to see if you can find out why the file was corrupted in the first place. You might have something like a failing disk.

Also, start taking backups!!!! I use SQL Server Backup, Integrity Check, Index and Statistics Maintenance

1 Like