[MSSQL 2000]The LSN passed to log scan in database 'model' is invalid..

MSSQL2000이 다운 됬다..

서비스 시작이 안되는 문제

 

Log를 확인해 보니 

\Program Files\Microsoft SQL Server\MSSQL\LOG

 

The LSN  passed to log scan in database 'model' is invalid..

 

.... 구글링 해보니 

 

OK. This should probably be a Microsoft professional services ticket, but here is what I would try. At all points, make sure you know where the original files are. never overwrite them.

1) Get your SQL 2000 CD. Look for the files model.mdf and modellog.ldf.
2) Copy these files to your server's harddrive.
3) Right click -> properties, make sure they are not read-only.
4) Save the original model.mdf and modellog.ldf from your data directory
5) move the model.mdf and modellog.ldf files from the CD to your data directory.
6) Cross fingers
7) Start SQL Service.

 

 

요약하자면 

SQL 2000 CD에서 Data(D:\Program Files\Microsoft SQL Server\MSSQL\Data) 경로에 model.mdf, modellog.ldf를 넣어주면 되는 것.. 

 

 

이틀은 까먹은거 같은데 의외로 쉽게 풀려 허무하다. 

 

그래도 살린게 어디인가 누군가에게 도움이되길