Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-07 : 07:05:17
|
| Steve writes "After running Chkdsk on a Server with several bad sectors, I realized I had lost the modellog.ldf file. I read enough about the problem to realize I need the file. I am a systems integrator with limited knowledge of SQL. I am involved in this issue because the system is primarily a Human Machine Interface. The database server is a secondary system to record data for production. The customer does not have their original MS SQL CDs and did not have a complete backup of the server.I need this file. Can you email it to me?Your assistance is greatly appreciated.Sincerely,Steve" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-09-07 : 07:21:44
|
| Check this article:http://support.microsoft.com/default.aspx?scid=kb;en-us;224071Read the entire article, and focus on the section regarding "Moving the model database". Instead of using sp_attach_db, you should use sp_attach_single_file_db, and attach the data file only, like so:sp_attach_single_file_db 'model','E:\Sqldata\model.mdf'Warning: I have never tested this to know if it works, but without the log file this may be your only chance. Using sp_attach_single_file_db should recreate the log file for you.Once you get it working again, MAKE A FULL BACKUP of all the databases and keep them in a safe place on another disk, preferably on another server. |
 |
|
|
|
|
|
modellog.ldf for SQL 7.0 Standard