SQL SERVER 2005 EXPRESS

Question

SQL SERVER 2005 EXPRESS

iloverickvill

SSC Rookie

Points: 34
More actions
March 11, 2011 at 9:55 pm

#246732

SQL SERVER 2005 EXPRESS
I cant start my SQL SERVER 2005.
I try starting it from services.msc bt it doesnt work.
I also try starting net start from command prompt. it started there but still my sql is STOPPED.
here is the event viewer log:
The log scan number (109:224: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.
please help me to fic this
you can view me in team viewer
id: 532 261 817
pass: 4597

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

mvillegascuellar SSC Eights! Points: 881 More actions · Answer 1

I think the error message is clear your model database is corrupted, I would recommend a simple solution for this, install a regluar SQL Server Express instance in another machine, after it is completly installed, shut it down (the SQL Server instance) and copy the mdf and ldf files of the model database into the one you have problems, finally start again your SQL server, I think this will solve your problem.

iloverickvill SSC Rookie Points: 34 More actions · Answer 2

thanks for the reply, but how about my data? how can i still manage to restore it?

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 3

You should not have any data in the model database - that is the database the SQL Server uses to build tempdb and as the 'model' for new databases that are created.

Your user database will not be affected by moving in a new copy of the model databaes or restoring that database from backup.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

iloverickvill SSC Rookie Points: 34 More actions · Answer 4

Where is the exact location of my databases that I will replace with the new one?

iloverickvill SSC Rookie Points: 34 More actions · Answer 5

whre is the exact location of my databases that i will replace with the new one?

mvillegascuellar SSC Eights! Points: 881 More actions · Answer 6

Hi,

As I told you, install a new instance of SQL Server Express in a new machine, once it is installed, run this command in the SSMS:

use model;

go

sp_helpfile;

go

This command will give you the exact path where you will find the model database files (*.mdf and *.ldf) in the new installation. Shutdown the new SQL Server instance. copy the files corresponing to the model database and paste then in the same path in the machine where you have problems (the path for SQL Server should be the same or similar). Once you replace the corrupted files with the new files, start your SQL Server instance, it should start with no problem, and all your databases will the the same as before the corruption ocurred.

I hope this helps.