SIMS SQL model database broken

[ReBoot]

One of my primary schools has a broken SIMS system. Looking at the logs the problem appears to be with the 'model' system database. Error is similar to the following:

 

Error: 9003, Severity: 20, State: 1

The LSN (4:188:1) passed to log scan in database 'model' is invalid.

 

LEA SIMS team have suggested I re-install SQL. School uses Redstor RBUSS for backups and has backups for the user databases including SIMS and FMS but none of the system databases including model and modellog. Model does appear to have been changed from the default which I can see in the templates folder.

 

Is re-installing SQL going to fix the problem and do I need a backup of model to bring everything back.

 

I have tried to start the server with the T3608 flag but even this seems to hang.

 

At the moment I am suggesting the school gets the LEA SIMS team out (very expensive) as I don't work with SIMS very often.

 

Anyone throw any light on how I can recover the system ?

[matt40k]

Did they check the backups have been working correctly? Next thing to check is why it got corrupted. Check Event Log to see if you have any bad blocks - ie replace the hard drive. If your good, could be the antivirus on-access scanning the .mdf \ .ldf - so might want to check you have an exception. More likely its hardware.

 

Once you've fixed the actual problem, you should get away with installing a new instance (call it sql2014 if it was sims2014 or install sql2014 if you had 2012) - then its just a question of restoring the database and update ini etc

[bobsmith]

I've not been playing with SQL recently, but the model database holds all the users and other useful things that SQL needs to know about.

 

restore it from a recent backup surely?

[ReBoot]

As far as I can tell there is no backup of any of the system databases inc. master model and modellog. Backup was setup by LEA team to only include the user databases. I have changed this for future backups !

 

I think its the master that hold all the users and SQL configuration and that one appears OK. The model is less critical.

 

I have seen it recommended that a model database from a foreign server with the same SQL version/service packs can be used to recover the system.

 

https://mssqlwiki.com/tag/model-database-corrupted/

 

I've just remembered I upgraded the disc on the SQL server last year and we still should have the old disc and contents. Might be a source for a backup model database for recovery.

[bobsmith]

I stand corrected, master is the really important one that needs backing up.

 

Do you not have a backup of the server that SQL is installed on? You could restore that somewhere and steal model from there?