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 - 2003-10-17 : 07:23:50
|
| Jay writes "Sir,I am gettting the following error message (in the error log) when i open my Db:Error: 9003, Severity: 20, State: 4The LSN(9421:220:1) passed to log scan in database "Fortune" is invalid.I understand that this could be some sync problem between the .MDF & .LDF files (maybe). I tried to detach the dbase (sp_detach_db) and reattach it without the .LDF (sp_attach_single_file_db) but still the same error is reported. I use SQL server ver. 7.0 with SP4 installed.Any help in this regard would be highly appreciated.ThanxJay.P.S. My backup is around a week old; and i would restore it as a last option. Please help." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-17 : 12:32:54
|
| Is the database marked suspect? Have you run DBCC CHECKDB? Is there enough free disk space on the drive where the database is located? Have you checked the Event Log for hardware problems.Tara |
 |
|
|
jhnegrao
Yak Posting Veteran
81 Posts |
Posted - 2006-03-24 : 13:05:58
|
| Anybody knows if use this procedure to attach master database with another name without ldf file is possible?Thanks |
|
|
|
|
|
|
Error message 9003